Query weeks

[UT227]

I have a date range (beginning date and ending date). How would I query out a list of weeks beginning with Monday (Mon-Sun)?

[June7]

Do you want to calculate the first day of week for each date in records?

Or do you just want to create a list of first day of each week out of thin air?

I doubt calculating this in query would be easy. VBA could write records to a table.

[UT227]

I just need a list of the dates for Mon and Sun. So, just the 2 dates. I don't need the dates between. Each of my date ranges begin with Monday. I was trying to find a way to get that date and just add 7 days. I'm just not sure how to go about it.

[UT227]

Figured it out. This worked for me.

[isladogs]

A slightly shorter version of the date filter is
Between ....StartDate And ...EndDate
with your Forms! reference used in place of the ...