help using date to notify a user of event

[pauly]

how would you address this situation, when a user sets a filed in a combo box to priority a timer needs to be set, so that in two weeks time the user who set the record to priority is notified (reminded) that the record needs to be attended to. I am thinking of just storing a date in a table and when the user logs on a function searches through all the dates to check if it is todays, the problem is setting it to exactly 2 weeks, is there any callender in access that could help

 

[scottfarcus]

What's wrong with Date + 14?

That will return the date exactly 2 weeks from today.