Records Not Appearing In Reports

[nelo]

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..

 

[DCrake]

Simple Software Solutions

Did you look in the raw data files to see if they existed?

Having said that they must have done as you said you deleted them an re-entered them. That leads me to believe that the recordsource of the report is the starting point of your audit trail. Something must have changed to exclude them. Has anyone been using the database over the weekend?

Have you tried recovering Friday's back up, that is of course you have one, and comparing the records?

CodeMaster: