Follow-up date

[bdhtexas]

Scenario:

A claim is sent to processing today 6/17/04 and we need to follow-up in 7 days to make sure it was completed.

How can this information be stored in the table, so that a query can be run at a later date that displays all the records that are 7 days are older, just in case we don't have time to work the follow-ups on a given day.

Any suggestions would be appreciated.

Thanks,
Brian

 

[RichO]

You don't want to store a calculated result in your table. As long as your claim date is stored in the table, just set up a query using =DateAdd("d", 7, [ClaimDate]) as a field and then in the criteria enter <=Date().

This query will return all records where [ClaimDate] is 7 or more days past.