Chart Reports from a Query

  • Thread starter Thread starter HL
  • Start date Start date

HL

Registered User.
Local time
Today, 15:09
Joined
Feb 13, 2001
Messages
19
Help!!!!!!

I would like to run a chart report from a parameter query.

The query pull pulls data out of the table between two dates and this is working fine.
In the query, the field's are Date and the Criteria is: Between [Enter Month Start Date] And [Enter Month End Date] the other fields I have in the query are Fault , Total Number Of Faults For The Day: Count(Left([Fault],1))

When I have tried to create a column chart after transferring all of the details into the chart wizard and have produced the graph but there is no data.

When I go to open the report I have an error message come up saying "The Microsoft jet database engine does not recognize '[Enter Month Start Data]' as a valid field name or expression.

What am I doing wrong????? is there a simple solution to this problem???

Cheers

HL
 
Have the data that is input as promts as fields on the form triggering the chart and a query utilizing the fields as query criteria as opposed as prompts as the recordsource for the chart.
 

Users who are viewing this thread

Back
Top Bottom