Date restrictor for this week

  • Thread starter Thread starter Guest
  • Start date Start date
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,
 
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]
 
Back
Top