Text Box Showing Date Span on 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/14, Tue. 2/15,
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

Thank you in advance for your help. Have a good weekend.

 

[jrt121]

I posted a similar reply in another topic.
If you are using a form to enter the dates, place an unbound text box
in the report header. In the text box properties, the data tab, set
control source to:="For the period of " & Format([Forms]![Form
Name]![Beginning Date],"mmmm d"", ""yyyy") & " to " &
Format([Forms]![Form Name]![Ending Date],"mmmm d"", ""yyyy").

For headers with only one date, you can remove either the beginning
date or ending date stuff.

Hope this helps.

 

[Guest]

JRT, Thank you for your response.

I do not have a date span in a form or in my table for that matter.

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/14 through
Friday 2/18) the report contains 10 records for Tuesday 2/15, 5 for Wednesday
2/16 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/14/05 through 2/18/05

Thanks for your help JRT and everyone else.