expression in criteria to automatically calculate

M

michelle@fedex

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
 
K

KARL DEWEY

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.
 
Top