Query/Report Issue RRS feed

  • 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

    Friday, July 31, 2020 4:57 PM

All replies

  • 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

    Friday, July 31, 2020 5:27 PM
  • 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 ....

    Thursday, August 6, 2020 12:20 PM