Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Microsoft Access 2007 -- View Query Used In Report?

I need help navigating Microsoft Access Reports.
I am in the Report Designer, and I need to know the which menu selection will enable me to view the Query that was used in the report.
I have never used Access before.

like image 441
Tim Avatar asked Sep 16 '09 18:09

Tim


1 Answers

Open the report in design mode.
Press F4, you will be able to see the dropdown in the "Properties" window.
Choose "Report" from the dropdown. You will see the "Record Source" property below it.

That contains the query/table which is used to build the report.

like image 118
shahkalpesh Avatar answered Oct 03 '22 23:10

shahkalpesh