Graph error

B

Bill Gates

When i run a query as a query it works fine. When i try to create a graph
from this query it has an error stating that it does not accept the input
'Please enter a year' as a valid input. That input is from the column 'Year'.
Below is the sql it created.

TRANSFORM Sum([Percentage of Hours]) AS [SumOfPercentage of Hours] SELECT
[Activity] FROM [Activity Hours] GROUP BY [Activity] PIVOT [Year];

one query calculates the total hours for the year and the other calculates
the percentage each activity is of the total hours.

Help much appreciated.
 
D

Duane Hookom

You must set the data type of all parameters in crosstab queries. Select
Query->Parameters and enter:
[Please enter a year] Integer
 
Top