expression in criteria to automatically calculate

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

Guest

I have a quary which I want the criteria expression to stated that it should
go from the previous week Sunday to the following Saturday each week with out
having to go in and change the expression each week
 
Use this as criteria --
Between Date()-Format(Date(),"w")-7 and

Date()-Format(Date(),"w") subtracts the day of the week (with Sunday as 1)
from the current date.

Date()-Format(Date(),"w")-7 subtracts 7 days more days.
 
Back
Top