I'm working on a sales analysis report for a customer and I can't quite figure out how to create the index I need. Each record in the reporting table contains Item, Description, Order Taker and Year To Date Sales. They would like to have the data reported in Order Taker order with a page break between each. The twist is they want an additional sort with in Order Taker on the Year To Date Sales in descending order. So in the end you get a listing of all items some one sold sorted by largest YTD Sales first. I need the Order Taker in ascending order and the Year To Date Sales in descending order. Is there a way to do this?

Thanks In Advance