Getting the SQL out of an Access 2000 reports

[PJ6]

I have a few Access 2000 reports that I need to get the SQL out of - that
is, exactly the logic it is using to get information from source tables.

This is apparently beyond my current understanding of Access or my ability
to get this information using Google.

Can anyone help?

Paul

 

[Van T. Dinh]

Check the RecordSource Property of the Reports. This Property is in the
"Data" tab of the Report's Properties window. You should also check the
Filter Property on the same tab.

Note that both Properties can be changed by code (but not often) so these
may not be the actual source of the data as presented in the Report.

HTH
Van T. Dinh
Microsoft MVP (Access)