Date restrictor for this week

G

Guest

Hi,

I want to create a report that will always give sales for the current week
starting with monday and going to friday. We are closed on Saturday and
Sunday but if a sales manager runs a report on friday or saturday, it would
give him sales for this week.

Thanks,
 
J

John Vinson

Hi,

I want to create a report that will always give sales for the current week
starting with monday and going to friday. We are closed on Saturday and
Sunday but if a sales manager runs a report on friday or saturday, it would
give him sales for this week.

Thanks,
Click to expand...

You can use Access' builtin date functions to do this. A criterion of
= DateAdd("d", -DatePart("w", Date()), Date()) AND < DateAdd("d", 8-DatePart("w", Date()), Date())
Click to expand...

will get from the previous Sunday through next Sunday.

John W. Vinson[MVP]
 

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

Date restrictor for this week 1
Date Restrictor for Last Week 1
Week and days query 8
Date Restrictor 3
Date Restrictor for last week's sales 1
Date Restrictor for last business day 3
Date Restrictor for Last Month 5
Date Restrictor for this month 1

Top