printing weekly format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with grouping by the week.

How do I get a date range to print as a header. If I put ww in a control
box in the header I just get the week number (ex. 32)

I would like it to print 8/1/05 - 8/7/05
 
Stefan said:
I have a report with grouping by the week.

How do I get a date range to print as a header. If I put ww in a control
box in the header I just get the week number (ex. 32)

I would like it to print 8/1/05 - 8/7/05
Click to expand...

Make the control source for the text box:

=Format([Date1], "mm/dd/yy") & " - " & Format([Date2], "mm/dd/yy")

where Date1 and Date2 are your date fields, of course.

Tom Lake
 
Back
Top