By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,307 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

multiple queries with same paramater

P: 1
I have multiple queries tied to one report. All queries have the same parameter (Enter State Date) and (Enter End Date). How can I set up my report so I only have to enter the Start Date and End Date once?
May 19 '17 #1
Share this Question
Share on Google+
2 Replies


PhilOfWalton
Expert 100+
P: 1,430
If you are using different queries as the RecordSource of a single report, how are you "telling" the report which query to use when it opens?

Phil
May 19 '17 #2

NeoPa
Expert Mod 15k+
P: 31,417
Hi Mindy.

That's a good question from Phil. Typically a query or other source of data is used as the Record Source for a Report or Form. Sometimes they have SubForm/Reports which have their own Record Sources. Sometimes the main Record Source is a query that uses a number of other queries within it.

We would certainly need to understand what your specific situation is better before we can give you appropriate help.
May 19 '17 #3

Post your reply

Sign in to post your reply or Sign up for a free account.