Combining Queries

G

Guest

I have several queries which are identical in structure and use the same
field names except for one field that uses an expression (the expression is
what makes the queries different).

How would I create another query that combines these queries back together
again?
 
G

Guest

One more thing...

I would like to accomplish this (if possible) without creating new tables or
appending records.
 
T

tina

suggest you read up on Union queries in Access Help, to see if that will
suit your purpose.

hth
 
C

CompGeek78

I have several queries which are identical in structure and use the same
field names except for one field that uses an expression (the expression is
what makes the queries different).

How would I create another query that combines these queries back together
again
Click to expand...

Why not just make one query that has all of the expressions in the
same query instead of many queries?
 

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

Data Mismatch in Excel 2010 4
DLookup and Nz 0
Combining Queries 4
How Can I join Two Queries? 3
Field name alias does not stick 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Select Queries 1
USING TABLE VALUE IN "BETWEEN...AND" EXPRESSION 5

Top