I have been asked to modify a report that my company uses. The report has been around for a long time, the person who wrote it is long gone and I know almost nothing about Access...

When I go into the design view on this report and look at Properties ->Data and choose "Report" from the drop down box I find a query that goes against a SQL database. I copy paste this query into SQL and get 1486 records back, however, when I run the report itself I get close to 2,000 records back. So I am trying to figure out where else to look to identify where this report is getting its' data from?

Any ideas as to where else I could look to find other queries that this report might be using to get its' data would be greatly appreciated.

Thanks!

Can you post the recordsource of the report, and any other event procedures behind the report

Thanks for the response. I have figured this one out.