End of statement missing?

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

Hi I have pasted my sql statement and got the following
result can someone tell me where I have missed something
because I get

I get the message saying compile error: expected end
statement

Thanks
Terry

currentdb.execute "INSERT INTO tblbadreadings (
SAINumber, Tarrif, MeterNo, Reading, Username, ReadDate,
dateadded )
SELECT tblreadings.SAINumber, tblreadings.Tarrif,
tblreadings.MeterNo, tblreadings.Reading,
tblreadings.Username, tblreadings.ReadDate,
tblreadings.dateadded
FROM tblreadings
WHERE (((tblreadings.SAINumber) Is Null)) OR
(((tblreadings.Tarrif) Is Null)) OR
(((tblreadings.MeterNo) Is Null)) OR
(((tblreadings.Reading) Is Null));"


Thanks

Terry
 
If that's exactly how your code looks then you'll be having problems with
the sql string getting interpreted correctly as a single string. Try
this...

CurrentDb.Execute "INSERT INTO tblbadreadings (" + _
"SAINumber, Tarrif, MeterNo, Reading, Username, ReadDate, " + _
"dateadded ) " + _
"SELECT tblreadings.SAINumber, tblreadings.Tarrif, " + _
"tblreadings.MeterNo, tblreadings.Reading, " + _
"tblreadings.Username, tblreadings.ReadDate, " + _
"tblreadings.dateadded " + _
"FROM tblreadings " + _
"WHERE (((tblreadings.SAINumber) Is Null)) OR " + _
"(((tblreadings.Tarrif) Is Null)) OR " + _
"(((tblreadings.MeterNo) Is Null)) OR " + _
"(((tblreadings.Reading) Is Null));"
 
Back
Top