I have a query a report is based on that takes dates from a form to set the date range. The criteria is:
Between [Forms]![frmPlantReports]![Text4] and [Forms]![frmPlantReports]![Text6]
When I try to create a chart that includes dates I get an error that the Microsoft Jet database engine does not recognize '[Forms]![frmPlantReports]![Text4]' as a valid field name or expression.
The query runs fine I just need to create a chart. Anyone have any ideas on this?
John Green
Between [Forms]![frmPlantReports]![Text4] and [Forms]![frmPlantReports]![Text6]
When I try to create a chart that includes dates I get an error that the Microsoft Jet database engine does not recognize '[Forms]![frmPlantReports]![Text4]' as a valid field name or expression.
The query runs fine I just need to create a chart. Anyone have any ideas on this?
John Green