Date Span in Report

[DD]

I need to add two fields to a report that display the
earliest date on the report and the latest date on the
report. The data comes from a query where the user puts in
the early date they want on the report and the data for
the next 14 days is on the report automatically.

 

[Rick]

what are the prompts that the user gets? You will need to add an unbound
text filed with the prompt in the field. For example, let's say it asks the
user to "EnterStartDate"...

Your field would be:

=Format([EnterStartDate],"Short Date") & " Through " &
DateAdd("d",14,Format([EnterStartDate],"Short Date"))

This would result in something like: 03/01/04 Through 03/15/04

Rick




I need to add two fields to a report that display the
earliest date on the report and the latest date on the
report. The data comes from a query where the user puts in
the early date they want on the report and the data for
the next 14 days is on the report automatically.