Grouping on a PageNofM count!
Posted on 2007-08-10
I don't know if this is even possible. But somehow I gotta do this, so any ideas at all would be helpful.
I have a statement report. Its all of our customer's statements in 1 report . On each statement I use the page n of m special field to count how many pages are in the statement. It resets when a new statement comes up. I need to create a formula that say if the statement is 1, 2 or 3 pages long then "1 - 3 pages" else if the statement is 4, 5, 6, 7, 8 or 9 pages long then "4 - 9 pages" else if the statement is 10+ pages then "10+ pages" so thats easy I did that.. but now I need to group on that. I need all the 1 - 3page statements together followed by 4 - 9 page statements, followed by the 10+ page statements. I can sort or group by this.... does not matter as long as they are all together. Our accounting dept needs different envelopes for each of those groups for the folder stuffer machine and they cannot go through 7,000 statements every month to filter them out by hand. PLEASE HELP!!!!!!