asked on

MS ACCESS

I really like the MS ACCESS report, "A" I did based on Query "A".
I copied Query A to Query "B", and made one chg, replacing one field with another.
I made a copy of Report A, and named it Report B.
What do I have to do to make Report B use as its source, only Query B?

Jim Horn

Go into Design View of report B, and change the Record Source Property to query B.

Kent Dyer

Query A and Query B can be represented like tables or what is called a RecordSet. Assuming you are using a "pass-thru" from Access, you can go to Design view, but one step further, SQL View.... but wait, you need to look at the connector and check to see where the data is coming from - it should be a DSN (like an ODBC Connector) which should point to the SQL Server, database, table, etc.

HTH,

Kent

ASKER CERTIFIED SOLUTION

Jim Horn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

IrogSinta

If the reports are is similar, it's better to use the same report, revise the query to include both fields, and add a parameter when opening the report to determine which field to show. This way you'll only have 1 report and 1 query instead of 2 of each just because of a single field. The advantage is a smaller database, and if you need to make a change to something on the report, for instance, the company's phone number, or in the query, you won't have to go to 2 places to make the change.

Jeffrey Coachman

<aside>
Also consider just using the SQL as the recordsource for the Report (or form)
This will reduce the size of the DB even further. It also eliminates the possibility of someone deleting the query by accident.

Jim Horn

Thanks for the grade. Good luck with your project. -Jim