Van,
Bowing head before the GREAT MASTER a BIG BIG THANKS
"Van T. Dinh" wrote in message
...
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
|