Using date variables from table in query

[Skybeau]

Hi guys,



I have a table that contains dates (Saturday through Friday). When I set up my query, I would like data returned where the date in a field is between the Saturday date and Friday date. Is there anyway to do this n the query without hard coding the dates in and manually changing the dates every week?

Cheers.

[bcofie]

There is a weekday and weekdayName function you can use. Try those.