Hi Guys,

I am not getting why I can't 3 0's to display. I get an error message
"Expecting End of Statement" while to trying to compile this code AND if I
leave 000 with nothing I get 1 0 and I need 3 to display in combination with
the CustomerID. Cananyone point me in the right direction?

DoCmd.RunSQL "INSERT INTO tblGetAUPReferenceID ( garCustomerID,
garAUPReferenceID )SELECT tblCustomerProfile.cpCustomerID, [cpCustomerID] &
"000" AS ID FROM tblCustomerProfile;"

Thanks,
Gina