Condense queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Warren Zitzow - 06 Nov 2007 04:17 GMT

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.

Reply to this Message

John Spencer - 06 Nov 2007 12:48 GMT

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.

Signature

John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

>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.

Reply to this Message

KARL DEWEY - 06 Nov 2007 20:42 GMT

Why not explain your situation a little more and maybe someone can suggest a
way to reduce the number of queries.

Signature

KARL DEWEY
Build a little - Test a little

> 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.

Reply to this Message