Microsoft Access 2007 -- View Query Used In Report?

ms-access reporting ms-access-2007
Tim picture Tim · Sep 16, 2009 · Viewed 10.4k times · Source

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.

Answer

shahkalpesh picture shahkalpesh · Sep 16, 2009

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.

Related questions

End User Ad-Hoc Reporting Tool: Microsoft SQL Server Management Studio or Microsoft Access?

Our centralized IT department has suggested two primary ad hoc query tools for our general user base of approximately 200 staff members: Microsoft SQL Server Management Studio 2008 (SSMS) Microsoft Access 2003 Environment The backend database is a read-only Microsoft SQL Server 2005 database. …

Read More
How to do INSERT into a table records extracted from another table

I'm trying to write a query that extracts and transforms data from a table and then insert those data into another table. Yes, this is a data warehousing query and I'm doing it in MS Access. So basically I want …

Read More
How to SUM two fields within an SQL query

I need to get the total of two fields which are within the same row and input that number in a field at the end of that same row. This is my code. Sum(tbl1.fld1 + tbl1.fld2) AS [Total] …

Read More