Discussion Locked

MS Access IIF statement

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to automatically populate the field "updated on" (using the iif statement)in a database with the current date when the field "completion date" is manually populated. I run daily engineering reports on items that were completed the day before but the Operations team is not always punctual in updating the "completion date" in the database causing late items to be missed on the reports.

1 reply

by amanabala

You might want to consider writing a peice of code that will update the field in question whenever the record is updated, not just when the "Completion Date" field is populated. If your users are updating data from a form, then you could put the code right into the form. If you need assistance with any of these, please let me know.
-Ravi

This discussion is closed to new replies.