I am attempting to generate a chart on a report in which the user is prompted
to select a [Beginning Date] data and [Enddate]. When I try and run this an
error message indicates "The Microsoft Jet Database engine does not
recognize'[Beginning Date]' as a valid field name or expression". Then
another error message pops up regarding the size of the data.
What can I do to allow the user to select the date range of the data and then
print a report with a chart on it?
Thanks,
K
Most row sources for charts are crosstab queries. Crosstab queries require
their designer to specify the data types of all criteria. This is done in the
query design by selecting Query->Parameters and entering:
[Beginning Date] DateTime
[Enddate] DateTime
Again, I would recommend treating your users to entering values into
controls on forms.
--
Duane Hookom
Microsoft Access MVP