group all 3 Trimesters of year on 1 report

[_Bigred]

Access 2000

I have a tblSICKusage that contains all the dates of the year that sick
leave was used and the amount used and employee name.

At work our review period is what we call a trimester (Jan-Apr 1st
Trimester, May-Aug 2nd Trimester, Sept-Dec 3rd Trimester).

Is there a way for me to group all these dates by trimester on one report,
so when I pull a employee sick leave usage it will give something like
below:

1st Trimester:
1/2/05 - 8 Hrs
2/7/05 - 3 Hrs

2nd Trimester:
5/1/05 - 7 Hrs
8/20/05 - 1 Hrs

3rd Trimester:
9/5/05 - 8 Hrs

Trying to make this a simple as possible,
TIA
_BIgred

 

[Marshall Barton]

Access 2000

I have a tblSICKusage that contains all the dates of the year that sick
leave was used and the amount used and employee name.

At work our review period is what we call a trimester (Jan-Apr 1st
Trimester, May-Aug 2nd Trimester, Sept-Dec 3rd Trimester).

Is there a way for me to group all these dates by trimester on one report,
so when I pull a employee sick leave usage it will give something like
below:

1st Trimester:
1/2/05 - 8 Hrs
2/7/05 - 3 Hrs

2nd Trimester:
5/1/05 - 7 Hrs
8/20/05 - 1 Hrs

3rd Trimester:
9/5/05 - 8 Hrs

Trying to make this a simple as possible,

Maybe a little too simple to get a good answer, but you can
set the report to group on an expression like
Month(datefield) / 4

 

[_Bigred]

Thanks Marsh I will check that solution out, and post a response.
_Bigred

 

[Bob Howard]

I suggest that in the query underlying the report you create an additional
"calculated column" which would be the trimester number. Using an iif
statement examining the date, set the value of this column. You can
sequence the report on that column as well. Then specify that column within
the report as the one to group on. Bob.