Filter for Work Week

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

Guest

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

how do I obtain data for Friday & Saturday on a Monday 1
Week and days query 8
ignore saturday and sunday in access queiry 1
Date Question 4
date parameter problem 1
Filter for Day of the Week 4
Automatic Data Extraction for Fri-Sat-Sun on Mondays 1
Date Restrictor for Last Week 1

Top