Records Not Appearing In Reports

[nelo10]

I'm running an Access 2003 database and nothing was altered over the weekend, but when I open it up today and run a report, several records are missing from the report. The records show up just fine on the form search, but I have no idea why they're not showing up now on the report.
Anyone have any idea what couldve caused this and a possible way of fixing it?

also, the only way of making the missing records show up on the report so far, has been by deleting and re-entering them..

 

[dhookom]

The only records that will display in a report are those that display in the report's Record Source query. These may be further limited by applying a filter to the report.

I expect your query isn't returning the results you expect. We don't have any idea how your tables/queries are structured so it is difficult to tell you what to try.

Are you opening the report with a Where Condition? Is there anything in the Filter property?

Duane
Hook'D on Access
MS Access MVP