- Joined
- Oct 20, 2007
- Messages
- 2
- Reaction score
- 0
Hello All
I have a number of Reports that print quarterly week numbers, such as:
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
The dates of the week numbers are not impotant. However my client wishes to be able to print any sequential number of weeks, such as: 05 to 32 ( where 05 and 32 are week numbers). The two fields invloved are:
Field Name Data Type
WKNUMBER Numeric
WKENDING Date/Time
All Reports and Forms are opened from a Menu.
All four reports mentioned above are based upon a Parameter Query with the following code in the Criteria Window of the Query:
between 01 and 13 (as an example of the 1st Quarter)
What is the code required to print a Report that enables the user to print any sequential set of week numbers? My VBA skills are very limited so be gentle with me.
Regards
Terence
London
I have a number of Reports that print quarterly week numbers, such as:
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
The dates of the week numbers are not impotant. However my client wishes to be able to print any sequential number of weeks, such as: 05 to 32 ( where 05 and 32 are week numbers). The two fields invloved are:
Field Name Data Type
WKNUMBER Numeric
WKENDING Date/Time
All Reports and Forms are opened from a Menu.
All four reports mentioned above are based upon a Parameter Query with the following code in the Criteria Window of the Query:
between 01 and 13 (as an example of the 1st Quarter)
What is the code required to print a Report that enables the user to print any sequential set of week numbers? My VBA skills are very limited so be gentle with me.
Regards
Terence
London