Query/Report Issue

Question

I have a table, query and report that are confusing me.  I enter a record in the table and it will display when I run the query.  I have a report that is based on the query but the record does not display.  As far as I can see, there is nothing in the query that would omit that particular record.  As a matter of fact, I modified the query to run all records in the group and it still does not display.

Any suggestions?

---

Thanks PU_RJF

Answer 1

You have most probably, inadvertantly, set a filter on the report.  Check the report properties of there is any value in the filter property.

Also, edit the reports Record Source and run it to see if any records are returned there.

---

Daniel Pineault, 2010-2019 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 2

as DP notes - there is a Report object function you have not yet discovered....  it could be Grouping...possibly code at the OnFormat event of a section.

you can sanity check by whipping up a quick & dirty new report object - without any feature - and source in on that query ....