data not showing in report

R

Ron Thetford

I have a simple query with just a prompt for the date. I created a report
with the query as the record source. When I run the report no data displays.
If I take the date prompt out of the query and run the report all the data
displays. What have i done wrong?
 
M

Marshall Barton

Ron said:
I have a simple query with just a prompt for the date. I created a report
with the query as the record source. When I run the report no data displays.
If I take the date prompt out of the query and run the report all the data
displays. What have i done wrong?
Click to expand...


We need to see a Copy/Paste of the query's SQL view along
with the data type of the field in the table.
 
O

Ofer

If you run the query without the report, do you have any records displayed?
If no, then the problem is with the query and not with the report.
In that case, can you post the SQL of the query, so we can have a look?
 
R

Ron Thetford

I found a person at work who had me change the field name of date to day in
the query and format the thing, of which i will never remember, but it now
works.
 
Top