selection criteria embedded in access report

[jassie]

Since I am new to working with access 2007 reports but I have reporting expereince using sql server 2008 r2 reporting service, I have the following question to ask.

When I run the sql alone that is behind an access 2007 report, I get x-number of rows selected. However when I run the actual access 2007 report, I am missing about 10% of the rows that appeared when I just ran the sql that is behind the access 2007 report.



Thus can there some some selection criteria embedded in the access report that restricts some rows from appearing on the report? If so, can you tell me what to check in a report to see where this extra selection criteria can be at?

[David04845]

the query feeds the report so all records in the query will show on the report (assuming the query is inside of access)

you either have more pages that you are not seeing (for instance all data on page 1 then 5 blank pages then 6th page of the last data then more blanks) or you have added a field during the construction of the report that varies from the query like a date function etc.

remake the report using the wizard and see if it corrects itself. if not then identify exactly what records are missing and see what is unique about them.