Report to Display 5 days form date. (1 Viewer)

djshrew

Registered User.
Local time
Today, 03:09
Joined
May 29, 2006
Messages
60
How can i make my reports only show me 5 days from a date of the report.

Date i want to work form is. "EmployeeDateFrom" control Source.

I want to show where that employee was that week.

Thanks in advance.

Sorry if not explained very well i am rubbish at access.
 

namliam

The Mailman - AWF VIP
Local time
Today, 04:09
Joined
Aug 11, 2003
Messages
11,695
Try looking into the access help for the DateAdd function, this allows you to "move dates"
 

vbaInet

AWF VIP
Local time
Today, 03:09
Joined
Jan 22, 2010
Messages
26,374
Or you can also add 5 to it, [Datefield] + 5
 

Users who are viewing this thread

Top Bottom