Hi,
Please let me know what's wrong with the below, its giving error in
the last where the value is "True". Error is "Syntax Error in Insert
Into Statement"
INSERT INTO tblPOTracker (transDate, buyerName, businessGroup,
buyerReq, NoOfLines, reqCreatedDate, requestorName, buyerPO,
poSupplier, requestStatus, reqReceivedTime, reqClosedTime,
poTATLapsed, poTAT, poTATMissComments, poRemarks, poConfirmed,
confirmMode, approvalStatus, poPlaced) VALUES ('1/12/2008', 'Navin' ,
'HPS', 1234,3, '1/12/2008', 'navi', '34545', 'save test',
'Standard','1/12/2008 7:16:36 PM', '1/12/2008 7:16:14 PM', '-24:00',
'', '', '', '', '', 'Pending', True
Thanks,
Navin
MikeR - 12 Jan 2008 15:18 GMT
> Hi,
>
[quoted text clipped - 13 lines]
> Thanks,
> Navin
Two things:
You have 20 fields, but only 19 values
No closing parenthesis
HTH
Mike
Steve Schapel - 13 Jan 2008 06:37 GMT
... and a third thing: dates should be delimited with #s instead of ''s.

Signature
Steve Schapel, Microsoft Access MVP
> Two things:
> You have 20 fields, but only 19 values
> No closing parenthesis
> HTH
> Mike
MikeR - 13 Jan 2008 12:53 GMT
> ... and a third thing: dates should be delimited with #s instead of ''s.
Nice catch!