I have a report that captures data rows from a table that has codes that have the same first 2 characters but different last 2 characters for distinction. I'd like my report to group by like codes (first 2 characters). My report is already grouped on this table/field so the printing/sorting is correct but I'd like each "like group" to print per page. I figured I'd have to create a formula in group footer when selecting New Page After. Can anyone help?
Thanks in advance.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.