SQL statement not working but will not give me any error either.

[nmapeso]

Try to update the check box ysnSentByMailToStaff if unchecked and dteFUDate = Date(), when ysnSentByMailToStaff = 0
No error shows up but wil not update.
Any help greatly apprecaited.


DoCmd.RunSQL "UPDATE tblCreditDetails SET tblCreditDetails.ysnSentByMailToStaff = -1 & tblCreditDetails.dteFUDate = Date() WHERE(((tblCreditDetails.ysnSentByMailToStaff) = 0))"

Thanks

 

[lespaul]

maybe:

UPDATE tblCreditDetails ysnSentByMailToStaff = -1, dteFUDate = Date() where ysnSentByNameToStaff = 0

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[nmapeso]

Hi leslie,

Try that one give's me a syntax error....

 

[nmapeso]

I got it fixed thanks...