Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

nmapeso

Technical User
Joined
Aug 26, 2005
Messages
28
Location
US
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
 
maybe:

Code:
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
 
Hi leslie,

Try that one give's me a syntax error....
 
I got it fixed thanks...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top