Condense queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report and am having to make 26 queries in order to get the all of
the required information, what I would like to know is if there is a way to
contain all the queries together to avoid confusion with queries for other
reports.
 
You can name the 26 queries so they group together on the name (alpha sort).
my26_GetNames
my26_GetAddresses
....

If you are using Access 2000 or later you can create a Group in the database
window and drag the 26 queries into the group.
Then if you wish, you can set each query's visible property to False. That
will hide them in the main query window, but they will still be visible in
the Group you have created and you can access them from the Group.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Why not explain your situation a little more and maybe someone can suggest a
way to reduce the number of queries.
 
Back
Top