Date automatically updating

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

Guest

I am working on a report in Access 2000 and I want to have a date be put in
either the report header, page header, anywhere, but I want it to
automatically update each week. For instance everyweek when I pull up the
report it would read Week Ending: (Saturday's Date), then the following week
it would have that Saturday's date.
 
Put the following in a textbox in your header( including the quotes for the
text):

="Name of Report - Week Ending: " & Date()+7-Weekday(Date())

The 7 will set it to Saturday, so you can change that to whatever day of
week you want it to display.
 
Back
Top