Filter for Work Week

L

lawman

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?
 
D

Duane Hookom

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?
 
R

Robert_DubYa

Use the dayofweek function and an iif statement as criteria.

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