Filter for Work Week

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

Guest

I have a query that I need to skip Saturday and Sunday when it runs. So when
I run it on Monday, it picks up Friday's data. On Tuesday it will pick up
Monday's data. Any idea how this can be done by VB or with criteria?
 
I think you are asking us to help you modify a criteria that we can't see.
Would you share your current SQL view of your query?
 
Use the dayofweek function and an iif statement as criteria.

iif(dayofweek[your date] = 2, [your date] -3,[your date]-1)
 

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

Week and days query 8
How to write a query that add 1 working day to the date 2
how do I obtain data for Friday & Saturday on a Monday 1
Easy question (just not for me) 2
Exceptions in Query 4
Multiple IIF Statement... 4
Filter for Day of the Week 4
report in access (Count) 1

Back
Top