J Jan Newton Apr 15, 2004 #1 Can I make a new query from several queries? I am trying to obtain information from other queries to build a labels query. Jan
Can I make a new query from several queries? I am trying to obtain information from other queries to build a labels query. Jan
G Guest Apr 15, 2004 #2 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!
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!
J Jeff Boyce Apr 15, 2004 #3 Jan Yes. When you create a new query, you get to pick which tables OR QUERIES you want to use as "source".
Jan Yes. When you create a new query, you get to pick which tables OR QUERIES you want to use as "source".
S Sandra Apr 15, 2004 #4 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.
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.
