I need to find a way to create a dynamic 3 column combo box (1 will be week number, 2 & 3 will be date range from/to)

It should be able to start on a specific date and end with current week. I have a week number combo built (See below) but I don’t know if it will work after the new year. And I don’t know how to put the date ranges into the mix.

Does anyone know of a calendar that will give me the week number and a data range that I can plug into this project? This is almost the last bit of code for this project and I am ready to put this puppy to bed!

Thanks for any suggestions or help.

James

(See below)
Nothing is attached, but if you have weeknumbers or even dates (preferably dates even) you can pretty easily convert that to Mon-sun dates...

i.e. date() - Weekday(date(),vbMonday) + 1
Will revert any date to the previous monday, substituting Date() by your date field

Obviously
date() - Weekday(date(),vbMonday) + 1 + 6
Will be next sunday

If you want to use this in a query use a 2 instead of vbMonday

Good luck

Nothing is attached, but if you have weeknumbers or even dates (preferably dates even) you can pretty easily convert that to Mon-sun dates...

i.e. date() - Weekday(date(),vbMonday) + 1
Will revert any date to the previous monday, substituting Date() by your date field

Obviously
date() - Weekday(date(),vbMonday) + 1 + 6
Will be next sunday

If you want to use this in a query use a 2 instead of vbMonday

Good luck


Thank you for the information.

James