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?
willjxAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Go into Design View of report B, and change the Record Source Property to query B.
0
Kent DyerIT Security Analyst SeniorCommented:
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
0
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

IrogSintaCommented:
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.
0
Jeffrey CoachmanMIS LiasonCommented:
<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.
0
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Thanks for the grade.  Good luck with your project.  -Jim
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.