Query to pull Fri Sat Sun occurences in a specific month

MarieD

Registered User.
Local time
Today, 03:03
Joined
Dec 9, 2009
Messages
53
Access 2007 query that has a specific date range between #6/1/12014# and #7/1/2014# returns the date I need. How do I now get it to pull just occurrences on Fri Sat and Sun of the month of June?
 
Do you mind spelling this out for me? I've looked at the link, but not getting it...
in my Confirmed Date column of the query is the criteria Between#6/1/2014# and #7/1/2014#. In the blank column to the right, I would type what to get just Fri Sat and Sun occurrences?
 
Create a new field in your query, let's call it DayVal. It will look like this in your Query
Code:
DayVal: WeekDay([[COLOR="Blue"]DateField[/COLOR]])
Under the criteria put the numbers that relate to Fri, Sat and Sun (as seen in the link I sent earlier) which are 6, 7 and 1 respectively which means your criteria for this field will be:
Code:
1 Or >5
Greater than 5 of course covers 6 and 7
 

Users who are viewing this thread

Back
Top Bottom