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
|