Query of Queries

A

AGOKP4

Hi

How can I create a query of queries. I need it to combine the various query
summaries I made from my database so I can have it all on one page

Thanks!!!
 
J

Jerry Whittle

Check out Union queries in Help. If that isn't what you mean, please provide
more information and examples of the problem.
 
A

AGOKP4

Hello Jerry,

Sorry for the late reply. What i need to do is have the various queries I
made combined into 1 sheet. I have various categories Age group and counts,
cr group and count, Sex group and count etc.

I created separate queries for each and now want them on a single page for
ease of presentation. Perhaps querying the queries is not the right way to
go.

I tried the union queries you sent without any luck.
 
J

Jerry Whittle

Show us the SQL for a couple of the queries. Open the query in design view.
Next go to View, SQL View and copy and past it here. Some sample data and how
you would to see it would be nice too.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incone & Expenses Statement 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Append Crosstab Query to Existing Table 0
Display weeks from a Milestone 0
Auto populate value from one task to another in MS PROJECT 0
Adding data to MS Access from csv file 0
Page numbering with Merged Document and IF statements 1
Access Query to import from Sharepoint 0

Top