saving query result

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnW - 12 Nov 2007 03:46 GMT

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

Reply to this Message

Ken Snell (MVP) - 12 Nov 2007 04:05 GMT

Use that union query as the report's RecordSource.

Signature

Ken Snell
<MS ACCESS MVP>

> I'm sure this is easy one... I have a standard SQL Union Query:
>
[quoted text clipped - 14 lines]
> Thanks in advance,
> John

Reply to this Message

Duane Hookom - 12 Nov 2007 05:39 GMT

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

Signature

Duane Hookom
Microsoft Access MVP

> I'm sure this is easy one... I have a standard SQL Union Query:
>
[quoted text clipped - 14 lines]
> Thanks in advance,
> John

Reply to this Message

JohnW - 12 Nov 2007 06:02 GMT

Thanks for that, I knew there was a simple answer

> You shouldn't need to create a table. Save the query and use it later for a
> report if required.
[quoted text clipped - 17 lines]
> > Thanks in advance,
> > John

Reply to this Message