saving query result

J

JohnW

I'm sure this is easy one... I have a standard SQL Union Query:

SELECT [Foundry Ref #],[Location],[Style],[Date In/Out]
FROM [Shanks Mounts]
UNION
SELECT [Foundry Ref #],[Location],[Style],[Date In/Out]
FROM [Full_Cast ]
UNION SELECT [Foundry Ref #],[Location],[Style],[Date In/Out]
FROM [Sundries & Ausjewel];

The expected result appears in a table - good
But it doesnt save the table for use later, so I can create a report if
required.

I find any examples in this post or help

Thanks in advance,
John
 
D

Duane Hookom

You shouldn't need to create a table. Save the query and use it later for a
report if required.
 
J

JohnW

Thanks for that, I knew there was a simple answer

Duane Hookom said:
You shouldn't need to create a table. Save the query and use it later for a
report if required.

--
Duane Hookom
Microsoft Access MVP


JohnW said:
I'm sure this is easy one... I have a standard SQL Union Query:

SELECT [Foundry Ref #],[Location],[Style],[Date In/Out]
FROM [Shanks Mounts]
UNION
SELECT [Foundry Ref #],[Location],[Style],[Date In/Out]
FROM [Full_Cast ]
UNION SELECT [Foundry Ref #],[Location],[Style],[Date In/Out]
FROM [Sundries & Ausjewel];

The expected result appears in a table - good
But it doesnt save the table for use later, so I can create a report if
required.

I find any examples in this post or help

Thanks in advance,
John
Click to expand...
Click to expand...
 
Top