Try:

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

--
HTH
Van T. Dinh
MVP (Access)


"Gina Whipp" wrote in message
...
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