Need a "Valid Through:" date

[Merdina]

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!

 

[Duane Hookom]

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.