Graph error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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