How to select multiple queries and put together

  • Thread starter Thread starter CM
  • Start date Start date
C

CM

Hi

I hope I explain this ok...

I have a membership database and I have made several queries depending on
location of the member. (One for each place)

I want to add to the database, on the form somewhere, I need a place where I
can select which places to send a appropriate mailing/ballot paper to..

For example

( ) Manchester
( ) London
( ) Edinburgh
( ) Bristol

If I picked London and Bristol it would get the two queries which I have
already set up and put them together in one place ready to use for a mailing
list and I could use this query for mailing them out? Is this too
complicated to do? I am not that advanced, but like to learn!

I have thought about doing queries in various ways but I have over 50
locations and there would be too many combinations!!

Any help would be appreciated!

Thanks

Colin
 
I have thought about doing queries in various ways but I have over 50
locations and there would be too many combinations!!
Click to expand...

You're missing a very important Access feature: the Parameter Query.

You should NOT have a stored query with "Manchester" as a criterion.
It's not necessary!

Instead create a Form (let's call it frmCrit) with a Combo Box
(cboLocation), based on a table or list of values showing all your
locations.

In the criteria line of your query put

=Forms!frmCrit!cboLocation

Base your report on this Query, and put a command button on frmCrit to
open the Report. Now you'll be able to select a location (and add new
locations if need be) from the combo box, and the report will display
the results for the selected location.
 
Back
Top