Drisconsult
Technical User
Hello All
I have written an accounts database for a friend. At the moment I have four reports showing:
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
These are based on Select queries where the criteria widow has the following code for the 1sr Quarter:
between "01" and "13"
This works fine of course. However, the user needs to be able to select random week numbers out of the 52 weeks in any one year. What code is required for this procedure and where would this code be inserted. I am a relative beginner where VBA is concerned. So be gentle with me.
Thank you all for your help, which I know will come
Regards
Terence
I have written an accounts database for a friend. At the moment I have four reports showing:
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
These are based on Select queries where the criteria widow has the following code for the 1sr Quarter:
between "01" and "13"
This works fine of course. However, the user needs to be able to select random week numbers out of the 52 weeks in any one year. What code is required for this procedure and where would this code be inserted. I am a relative beginner where VBA is concerned. So be gentle with me.
Thank you all for your help, which I know will come
Regards
Terence