Union Make Table Query

[Wet_Blanket]

Good Afternoon,

I have the below Union Query that I want to turn into a make table query. But I can't figure out where to put the INTO clause. No matter where I stick it, I get errors.

SELECT acct_num, br_id, fa_id, acct_pgm, acct_pgm_assn_end_dt, client_tr_dt, trade_date, trans, symbol, shares, client_price, price
FROM [nonmgd BUYS]
UNION SELECT acct_num, br_id, fa_id, acct_pgm, acct_pgm_assn_end_dt, client_tr_dt, trade_date, trans, symbol, shares, client_price, price
FROM [nonmgd ClsdBUYS]
UNION SELECT acct_num, br_id, fa_id, acct_pgm, acct_pgm_assn_end_dt, client_tr_dt, trade_date, trans, symbol, shares, client_price, price
FROM [nonmgd SELLS]
GROUP BY acct_num, br_id, fa_id, acct_pgm, acct_pgm_assn_end_dt, client_tr_dt, trade_date, trans, symbol, shares, client_price, price;

 

[MSAccessRookie]

Good Afternoon,

I have the below Union Query that I want to turn into a make table query. But I can't figure out where to put the INTO clause. No matter where I stick it, I get errors.

SELECT acct_num, br_id, fa_id, acct_pgm, acct_pgm_assn_end_dt, client_tr_dt, trade_date, trans, symbol, shares, client_price, price
FROM [nonmgd BUYS]
UNION SELECT acct_num, br_id, fa_id, acct_pgm, acct_pgm_assn_end_dt, client_tr_dt, trade_date, trans, symbol, shares, client_price, price
FROM [nonmgd ClsdBUYS]
UNION SELECT acct_num, br_id, fa_id, acct_pgm, acct_pgm_assn_end_dt, client_tr_dt, trade_date, trans, symbol, shares, client_price, price
FROM [nonmgd SELLS]
GROUP BY acct_num, br_id, fa_id, acct_pgm, acct_pgm_assn_end_dt, client_tr_dt, trade_date, trans, symbol, shares, client_price, price;

See what happens if you add the following in front of your Union Queries, and then surrond the Union Queries with "(" and ")".

[B]Insert Into {YourTable}[/B]
[B]([/B]
[B][COLOR=green]{Union Query List From Above}[/COLOR][/B]
[B])[/B]

 

[Wet_Blanket]

That just gives me a syntax error...

 

[Wet_Blanket]

I think I'm approaching this all wrong. I'm just going to create a new make table query using the Union Query as its source. Much simplier.