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
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