I'm getting an error message that reads

Syntax error (missing operator) in query expression "Program ID'.

My Union Query is:
SELECT Program ID, program name, Sent, Delivery Rate, Open Rate, # Clicks, Net Sales, Net Units, Net Orders, Gross Sales, Gross Units, Gross Orders
From [qrySonic_Circ_Repot_B1]
UNION Select Program ID, program name, Sent, Delivery Rate, Open Rate,# Clicks, Net Sales, Net Units, Net Orders, Gross Sales, Gross Units, Gross Orders
From [qrySonic_Circ_Repot_C1];

Can anyone please help me with this error?

Thanks
Corey

Hi Corey

I think you'll find you have to square bracket your field names as below

SELECT [Program ID], [program name], Sent, [Delivery Rate], [Open Rate], [# Clicks], [Net Sales], [Net Units], [Net Orders], [Gross Sales], [Gross Units], [Gross Orders]
From [qrySonic_Circ_Repot_B1]
UNION Select [Program ID], [program name], Sent, [Delivery Rate], [Open Rate],[# Clicks], [Net Sales], [Net Units], [Net Orders], [Gross Sales], [Gross Units], [Gross Orders]
From [qrySonic_Circ_Repot_C1];


SQL does not like spaces between field name, it assumes that they are separate fields.

Martin