Format of Date from Filtered Report

[Guest]

Dear Professionals:
I have several reports which I filter with a query on dates that I print
each Friday. We will not necessarily have entries on each report daily. In
fact, some report will contain for example, entries on Mon. 2/21, Tue. 2/22,
but not Wed., Thur., or Fri. But I will need the text box on the reports to
reflect Monday through Friday in each of the instances shown below.

I need to create variations of headers that do the following:

REPORT 1 HEADER: Data For Monday, February 14, 2005 through Friday, February
18, 2005

REPORT 2 HEADER: Data For 2/14/05 through 2/18/05

REPORT 3 HEADER: Data For Week Ended 2/18/05

REPORT 4 HEADER: Data For Week Beginning 2/14/05

I do not have a date span in my table. The text box will be based soley upon
the single entry date.

What will need to be done is in the text box in the header I will need to
show the minimum date from the filtered report and then the ending date as a
count of plus four days. Now where this gets funky is for instance this week
(Monday 2/21 through Friday 2/25) the report contains 10 records for Tuesday
2/22, 5 for Wednesday 2/23 and none for the other days of the week. BUT, the
text box on the report header will show:

TASKS for the week of 2/21/05 through 2/25/05 (and variations of the date as
shown above).

Thank you in advance.

 

[Marshall Barton]

I have several reports which I filter with a query on dates that I print
each Friday. We will not necessarily have entries on each report daily. In
fact, some report will contain for example, entries on Mon. 2/21, Tue. 2/22,
but not Wed., Thur., or Fri. But I will need the text box on the reports to
reflect Monday through Friday in each of the instances shown below.

I need to create variations of headers that do the following:

REPORT 1 HEADER: Data For Monday, February 14, 2005 through Friday, February
18, 2005

REPORT 2 HEADER: Data For 2/14/05 through 2/18/05

REPORT 3 HEADER: Data For Week Ended 2/18/05

REPORT 4 HEADER: Data For Week Beginning 2/14/05

I do not have a date span in my table. The text box will be based soley upon
the single entry date.

What will need to be done is in the text box in the header I will need to
show the minimum date from the filtered report and then the ending date as a
count of plus four days. Now where this gets funky is for instance this week
(Monday 2/21 through Friday 2/25) the report contains 10 records for Tuesday
2/22, 5 for Wednesday 2/23 and none for the other days of the week. BUT, the
text box on the report header will show:

TASKS for the week of 2/21/05 through 2/25/05 (and variations of the date as
shown above).

You never said where the date range in the filter is
specified. If it's a parameter prompt popup or a text box
on a form, then use the exact same thing in the report
header text box expression. For example:

="Data For " & Format(Forms!theform.thetextbox, "dddd, mmmm
d, yyyy") & " through " & Format(Forms!theform.thetextbox +
4, "dddd, mmmm d, yyyy")