MS Access Chart Wizard Reports

[C0PP3R]

Hey hey,

I'm building reports using the chart wizard within MS Access 97.

The report is based on two date fields and returns the information that falls between the 2 dates.

The criteria in my qry is as follows:
Between [Forms]![frmNCRReports]![begindate] And [Forms]![frmNCRReports]![enddate]

Now the qry runs just fine, so i know it's not a syntax problem, but when i run the report i get the following errormsg and the report opens up blank.:

The Microsoft Database engine does not recognize 'Between [Forms]![frmNCRReports]![begindate]' as a valid field name or expression.

Any help would be apreciated, Thank you

 

[kevinclark]

Misleading error

I don't have 97 to compare wizards but hopefully not too different from 2000


1) Open the report and insert a chart using the chart wizard.
2) Choose the query Press Next
3) Choose the Fields Press Next
4) Choose placement of the fields on the chart diagram and then press the chart preview button - If your chart is set up properly it should be viewable, if not then you will recieve the error you have been getting.

Hope it helps

 

[Guest_imported]

If I was you I would go back to the query with the Between [Forms]![frmNCRReports]![begindate] And [Forms]![frmNCRReports]![enddate] and right click on the top half of the query and select 'Parameters' and enter [Forms]![frmNCRReports]![begindate] as a date/time and [Forms]![frmNCRReports]![enddate] as a date/time...run the graph and it should be fine