Make Table From Union SQL query

[Guest]

How do I make a table from the result of this query:

SELECT [Raw Data].[CCSSBU Header], ibcUpd.YTD_ACTUAL_CHARGE, [FROM_CC_NBR] &
[Raw Data].[SS] & [BU] AS ibcHdr
FROM ibcUpd LEFT JOIN [Raw Data] ON ibcUpd.FROM_CC_NBR = [Raw Data].CC;

union

SELECT [Raw Data].[CCSSBU Header], ibcUpd.YTD_ACTUAL_CHARGE, [FROM_CC_NBR] &
[Raw Data].[SS] & [BU] AS ibcHdr
FROM ibcUpd RIGHT JOIN [Raw Data] ON ibcUpd.FROM_CC_NBR = [Raw Data].CC;

 

[Arvin Meyer [MVP]]

Save the query, let's call it Query1. Use the query in a Make-Table query.:

SELECT Query1.* INTO NewTable
FROM Query1;

 

[Guest]

Damn that was easy. I should have thought of it. I guess that's why YOU are
the mvp. Thanks so much.

Save the query, let's call it Query1. Use the query in a Make-Table query.:

SELECT Query1.* INTO NewTable
FROM Query1;
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

How do I make a table from the result of this query:

SELECT [Raw Data].[CCSSBU Header], ibcUpd.YTD_ACTUAL_CHARGE, [FROM_CC_NBR]
&
[Raw Data].[SS] & [BU] AS ibcHdr
FROM ibcUpd LEFT JOIN [Raw Data] ON ibcUpd.FROM_CC_NBR = [Raw Data].CC;

union

SELECT [Raw Data].[CCSSBU Header], ibcUpd.YTD_ACTUAL_CHARGE, [FROM_CC_NBR]
&
[Raw Data].[SS] & [BU] AS ibcHdr
FROM ibcUpd RIGHT JOIN [Raw Data] ON ibcUpd.FROM_CC_NBR = [Raw Data].CC;