saving query result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You shouldn't need to create a table. Save the query and use it later for a
report if required.
 
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...
 
Back
Top