General discussion


MS Access IIF statement

By bobeula ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by amanabala In reply to MS Access IIF statement

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.

Related Discussions

Related Forums