Data displays in reports

R

Ron Thetford

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
 
S

S Panja

Ensure that the functioning query is the record source for the report.
--
***************************
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?
 
J

John Vinson

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
Click to expand...

Doublecheck that the Recordsource property of the Report is in fact
this query, and that you're entering exactly the same dates. Note that
it's not necessary to "run" the query, other than as a debugging test.


John W. Vinson[MVP]
 
Top