Help with append query to add data on the fly

[Darkmatter5]

So here is my Append query currently.

INSERT INTO Customers ( PurchaseDate, ID_Name, FirstName, LastName, Address1, Address2, City, State, Zipcode, BatteryL1, BatteryL2, BatteryR1, BatteryR2, BatterySize, Tag )
SELECT AHC.Date, AHC.Name, AHC.[First Name], AHC.[Last Name], AHC.[Billing Address 1], AHC.[Billing Address 2], AHC.[Billing City], AHC.[Billing State/Province], AHC.[Billing Zip], AHC.[Battery - L (1)], AHC.[Battery - L], AHC.[Battery - R (1)], AHC.[Battery - R], AHC.[Battery Size], AHC.Tag
FROM AHC;

I have another field in the Customers table named "Organization", with this append query I need each record appended to Customers to put "AHC" in the "Organization" field while it appends each record. Is this possible?

Thanks!

[pbaldy]

Try

INSERT INTO Customers ( PurchaseDate, ID_Name, FirstName, LastName, Address1, Address2, City, State, Zipcode, BatteryL1, BatteryL2, BatteryR1, BatteryR2, BatterySize, Tag, Organization )
SELECT AHC.Date, AHC.Name, AHC.[First Name], AHC.[Last Name], AHC.[Billing Address 1], AHC.[Billing Address 2], AHC.[Billing City], AHC.[Billing State/Province], AHC.[Billing Zip], AHC.[Battery - L (1)], AHC.[Battery - L], AHC.[Battery - R (1)], AHC.[Battery - R], AHC.[Battery Size], AHC.Tag, "AHC" As Org
FROM AHC;

[Darkmatter5]

Perfect, thanks!

[pbaldy]

Happy to help!