table from union query

[jrb47]

How can you make a table from a union query in access - i have the union working and producing what i want but i can store it as a view or as a table - i keep getting syntax errors

INSERT INTO HgTotals

SELECT CollectionDate,HgTotalnglA as AllHGtotal
FROM HgPace

UNION

 SELECT CollectionDate,HgTotalnglB as AllHGtotal
FROM HgPace;

the end result is i need to use the unioned data for a calculations
so if someone knows how to use a query for data creation instead of a table that would work also i think

[buddylee17]

Save the union query. Create a new create table query that uses the union you just created.

[boblarson]

Why not just save the union query and use it in another query for your calculations just like using another query.