Weekend date in a report

[quinto via AccessMonster.com]

Can someone give me a simple expression to print the weekend date in a report
based on the date of the information entered in the details. I will have
daily reports but the invoiced cleint wants the weekeend date as well on top
of the daily reports.

Thanks

Quinto

 

[Ron2006]

WeekEndDate = DailyDate + (7 - datepart("w",dailydate))

Ron

 

[quinto via AccessMonster.com]

Sorry I need a bit more info my control field for the daily reports is name
ServDate (for service date)
I tried to place this expression in a text box in the report but was unable
to get going. Do I have to put this in the query?
Thanks Ron

Quinto

 

[John W. Vinson]

Sorry I need a bit more info my control field for the daily reports is name
ServDate (for service date)
I tried to place this expression in a text box in the report but was unable
to get going. Do I have to put this in the query?
Thanks Ron

Quinto

You should be able to put this or a related expression:

=DateAdd("d", 7 - Weekday([ServDate]), [ServDate])

in the Control Source of a textbox.

 

[quinto via AccessMonster.com]

It worked a like a charm

Thanks

Quinto

Sorry I need a bit more info my control field for the daily reports is name
ServDate (for service date)

[quoted text clipped - 7 lines]
You should be able to put this or a related expression:

=DateAdd("d", 7 - Weekday([ServDate]), [ServDate])

in the Control Source of a textbox.