Aerowolf
Programmer
- Nov 6, 2002
- 64
I am trying to sort and group a report based on 2 fields; we'll call them date and type.
I want to sort and group as such:
sort by date and group by month with each month on a separate page.
for each month i want to group by type with each type going on a separate page.
The result would be like this:
Page 1 January Type One
Page 2 January Type Two
Page 3 February Type One
Page 4 February Type Two
etc...
I thought I had it figured out but I run into problems if the data on any page runs over onto a second page.
Help!!
Edwin
I want to sort and group as such:
sort by date and group by month with each month on a separate page.
for each month i want to group by type with each type going on a separate page.
The result would be like this:
Page 1 January Type One
Page 2 January Type Two
Page 3 February Type One
Page 4 February Type Two
etc...
I thought I had it figured out but I run into problems if the data on any page runs over onto a second page.
Help!!
Edwin
