drawing a chart on a report

  • Thread starter Thread starter talktobatchu
  • Start date Start date
T

talktobatchu

Hello,

I'm trying to insert a chart on a report, the chart is
based on a query which takes 'year' as input from the
user and generates the result. The query works fine
separately, but when I run the report with chart
included, it gives a error message as: 'The Microsoft
database engine doesn't recognize [Enter the Starting
Year (>1989)] as a valid field name or expression'.

My query looks as follows::

SELECT HepatitisA_90to03Data.CountyName,
HepatitisA_90to03Data.YearField,
HepatitisA_90to03Data.Cases,
HepatitisA_90to03Data.Population,
HepatitisA_90to03Data.Rate, HepatitisA_90to03Data.District
FROM HepatitisA_90to03Data
WHERE (HepatitisA_90to03Data.YearField=[Enter the
Starting Year (>1989)] Or HepatitisA_90to03Data.YearField=
[Enter Ending Year]) And ((HepatitisA_90to03Data.District)
=[Enter the District Number]);


Also the Row Source of the chart has the code as
following::

TRANSFORM Sum([Cases]) AS [SumOfCases] SELECT [YearField]
FROM [HepatitisA_90to03Query] GROUP BY [YearField]
PIVOT [Cases];

Here I'm trying to retrieve data for the two years which
the user enters and draw a column graph to compare the
two records. Is there any possibility that this can be
done in access.

thank you in advance.

talktobatchu
 
The row source is a crosstab query so you need to enter the parameter
datatypes in one of your queries. I would do it in the first query. Open it
in design view and select Query->Parameters and enter:
[Enter the Starting Year (>1989)] Integer
[Enter Ending Year] Integer
[Enter the District Number] ?
 
Back
Top