expression in criteria to automatically calculate

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use In() Expression as Query criteria with guts from Function 1
Set Query Criteria to upcoming Saturday 2
Past Due Expression 1
Criteria not excluding data 2
Count Weeks in a Month 7
Specified Expression/Aggregate Funciton error 5
>or< expression criteria 2
Problem with expression (sum) 1

Top