Need a "Valid Through:" date

I am working on an access database to track personal and vacation time for
the employees at the company I work for.

I am running into a problem with the reports that I am building. I need to
have it show a "Valid Through" date, preferably in the report header.

I would prefer for it to calculate the valid through date automatically,
either the Sunday of the previous week (if I were updating it today, the
valid date would be Dec. 27th) or - if there is already a UsedDate after
that, the Sunday of that week.

Optionally, a pop-up box that asks me for the valid through date would be
acceptable - and possibly easier! Of course, I haven't been able to figure
out how to get it to do that either.

Thanks for any constructive help!

Is there anything in the report's record source that would help calculate the
"Valid Through" date? You can't just state "if there is already a UsedDate
after that, the Sunday of that week" without telling us something about the
UsedDate or where to find it.

--
Duane Hookom
Microsoft Access MVP


"Merdina" wrote:

I am working on an access database to track personal and vacation time for
the employees at the company I work for.

I am running into a problem with the reports that I am building. I need to
have it show a "Valid Through" date, preferably in the report header.

I would prefer for it to calculate the valid through date automatically,
either the Sunday of the previous week (if I were updating it today, the
valid date would be Dec. 27th) or - if there is already a UsedDate after
that, the Sunday of that week.

Optionally, a pop-up box that asks me for the valid through date would be
acceptable - and possibly easier! Of course, I haven't been able to figure
out how to get it to do that either.

Thanks for any constructive help!