query

  • Thread starter Thread starter Jan Newton
  • Start date Start date
J

Jan Newton

Can I make a new query from several queries? I am trying to obtain
information from other queries to build a labels query.

Jan
 
When you create a new query in design view, Access defaults to showing you the tables available. If you change the tab (at the top) to queries, you can select queries instead of tables. Join them like you would tables......

Hope this helps!
 
Jan

Yes. When you create a new query, you get to pick which tables OR QUERIES
you want to use as "source".
 
Yes, in fact this is often the way to distill data down.
Just use them as your source and create a report for the
labels based on your final query.
 

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

Combine Duplicates in Query 0
Parameter Query Won't Run 0
Use In() Expression as Query criteria with guts from Function 1
Delete Query: Could not delete from specified tables 0
Make table query: [Enter 1] AS Test 1
Make-table query with around 2 ml records taking too long 0
Query SELECT in SELECT? 2
Difference between queries 4

Back
Top