splitting out records

[Tim_Herrington_(Guest)]

Morning all____I wonder if you could help me again please, ____I have to modify a report that was written a while back by someone else, (always fun! ) anyway it is a margin by customer report the user has options that efectivly cause the report to display in 6 different ways, 3 of which are a summaries by customer, showing no of jobs how much they spent, margin, that sort of thing. ____what i need to achive is two blocks of data without using a sort if at all possible is to have all the customers A - Y listed down with a total at the bottom then all the customers begining Z (internal cost accounts) listed with a total. ____the report has grouping by Type (swapped header) then by Customer. the summary part of the report i am using is in the GF - Cust_acc____I hope i have given you enough info, thanks in advance for you assistance.____Tim :-)__

[kfleming]

You could add a grouping based on the calculation LEFT(CUSTOMER,1)="Z"__This will be false for the A-Y customers and true for the Z customers and would allow you to create group subtotals for each.____Kathleen__R&R Support

[TIM]

Hi Kathleen____You are a clever so and so, thanks very much :-)____I will let you know how i get on