data not showing in report

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

Guest

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?
 
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.
 
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?
 
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.
 
Back
Top