Date in the future flaging up a date in the past or visa versa. 2

[KCarter]

Ive a table and a form that contains info regarding hazard assessments. These have to be updated say two years hence. Is it possible that when a future Month arrives all records pertaining to that month flag up for review??

Regards
KC

 

[OnTheFly]

Not sure what you mean by arrives. If you are inporting and appending the new data you could at a field to the table to you are appending to called Flag as a boolean and in the process of adding the records, mark the flag field true for all related records.

Hope this helps.

OnTheFly

 

[Trevil]

Several ways to do this:
1. Create field in table named 'ReviewDate', then as you add/change records update that field to + 2 years.
2. Have query check if 'ReviewDate' has passed, then do whatever you need.

Or don't add new field - just have query automatically add 2 years to the field.

Code: Where the vision is often rudely introduced to reality!