reporting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple query that just is by date. I have the Between [start] and
[end] int the criteria. I run the query and I get the result. I use this
query in a report and when prompted for the data, I put in the date. The
form or labels of the report dispaly, but not data is displayed. I can remove
the criteria in the query, run the report and the data display, but of course
all the records display. I need to select just the records by the date range.
 
If the dates are not treated correctly, it may be that Access is
misunderstanding the dates.

To fix that, open the query in design view.
Choose Parameters on the Query menu.
Enter 2 rows in the dialog, like this:
start Date/Time
end Date/Time

I am assuming here that this criteria is applied against a date/time type
field in your table. If it is a calculated query field, see:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html
 
Back
Top