Query to pull Fri Sat Sun occurences in a specific month

[MarieD]

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?

 

[vbaInet]

Add an extra field in your query that only gets the Weekday() and put criteria under this field for those weekdays.

http://www.techonthenet.com/access/functions/date/weekday.php

 

[MarieD]

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?

 

[vbaInet]

Create a new field in your query, let's call it DayVal. It will look like this in your Query

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:

1 Or >5

Greater than 5 of course covers 6 and 7

 

[MarieD]

You are a genious!! Thank you so much.

 

[vbaInet]

You're welcome!