I have a date range (beginning date and ending date). How would I query out a list of weeks beginning with Monday (Mon-Sun)?
I have a date range (beginning date and ending date). How would I query out a list of weeks beginning with Monday (Mon-Sun)?
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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.
A slightly shorter version of the date filter is
Between ....StartDate And ...EndDate
with your Forms! reference used in place of the ...