If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"000" Not working
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook Rules not Working | Marty | General Discussion | 0 | May 6th, 2005 05:58 PM |
Working time and days | Nortos | Worksheet Functions | 5 | May 6th, 2005 04:17 PM |
Working time and days | Nortos | General Discussion | 1 | May 6th, 2005 03:47 PM |
Trace Dependents and Precedents not working | Manish | Worksheet Functions | 0 | April 11th, 2005 09:39 PM |
working offline | Felisa | General Discussion | 2 | March 2nd, 2005 02:32 AM |