View Single Post
  #5  
Old June 10th, 2005, 06:33 PM
Gina Whipp
external usenet poster
 
Posts: n/a
Default

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