Posted on 2013-09-06
Medium Priority
Last Modified: 2013-09-11
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?
Question by:willjx
LVL 66

Expert Comment

by:Jim Horn
ID: 39472153
Go into Design View of report B, and change the Record Source Property to query B.
LVL 17

Expert Comment

by:Kent Dyer
ID: 39472154
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.


LVL 66

Accepted Solution

Jim Horn earned 2000 total points
ID: 39472166
>replacing one field with another.
btw if Report B uses the field that you changed, you'll have to go into Design View of report B and change it to use the changed field.

These answers were brought to you by the letters A and B.
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

LVL 29

Expert Comment

ID: 39472167
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.
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39474729
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.
LVL 66

Expert Comment

by:Jim Horn
ID: 39484393
Thanks for the grade.  Good luck with your project.  -Jim

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question