mark curtis
Registered User.
- Local time
- Today, 18:43
- Joined
- Oct 9, 2000
- Messages
- 457
I have a recordset that store mandays, month and year.
I need to group a report so that if an employee has data in 2002 mth11,mth12 & year 2003 mth1 that would be one group. Then they have no data for 2003 mth2 but then they have data for mth3,4,5 & 6, that would be another group.
Basically I am looking to group where the month and year roll and if any months have no data then start a new group for the next consistant roll???
I need to group a report so that if an employee has data in 2002 mth11,mth12 & year 2003 mth1 that would be one group. Then they have no data for 2003 mth2 but then they have data for mth3,4,5 & 6, that would be another group.
Basically I am looking to group where the month and year roll and if any months have no data then start a new group for the next consistant roll???
