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

Using same query criteria input for multiple seperate query fields

P: n/a
I am using Access 2000 and I have a DB that is currently running four
different queries from some Forms and subforms. These queries each
have a date field that are seperate from each other that are from
those said forms. Currently I have setup the criteria for these
queries to prompt a user to enter a month #

Query Field: Month([Open Date Field])

Criteria: [Enter Month Number (1-12)]

This works fine on the indivdual queries but, I am trying to create a
report using subreports that shows all 4 queries together. Obviously
what is happening is that when I run this report, it is asking me for
a month number for each of the four seperate queries it is running.

Is there a way to take that query input (month number) and pipe it to
all four queries so the report brings up those 4 seperate queries
filtered by the month number the user specifies without the user
having to enter in a month number four serperate times?

Any help or leads would be awesome. Thank you.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
A common approach is to open a form with a textbox on it, and have each of
the queries refer to that text box, rather than a named criteria.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

"Steve" <ma***********@hotmail.com> wrote in message
news:3c**************************@posting.google.c om...
I am using Access 2000 and I have a DB that is currently running four
different queries from some Forms and subforms. These queries each
have a date field that are seperate from each other that are from
those said forms. Currently I have setup the criteria for these
queries to prompt a user to enter a month #

Query Field: Month([Open Date Field])

Criteria: [Enter Month Number (1-12)]

This works fine on the indivdual queries but, I am trying to create a
report using subreports that shows all 4 queries together. Obviously
what is happening is that when I run this report, it is asking me for
a month number for each of the four seperate queries it is running.

Is there a way to take that query input (month number) and pipe it to
all four queries so the report brings up those 4 seperate queries
filtered by the month number the user specifies without the user
having to enter in a month number four serperate times?

Any help or leads would be awesome. Thank you.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.