September 5, 200817 yr Greetings again -) Trying to get records to sort like this: Region, Price B, $6 B, $7 B, $9 C, $5 C, $6 C, $8 A, $4 A, $8 A, $9 That is, list the regions in order of which has the highest lowest price. The lowest price in B is $6 which is higher than the lowest prices in C and A. So I want to put the prices in order for each region, then put the regions in order according to the one with the lowest price. Can this be with Sort? BY using a summary field somehow? If not, with a summary report? Been struggling with it. Thanks
September 5, 200817 yr Author Wow. How did you figure that out so fast. I guess I didn't fully understand how reordering with a summary worked. Thanks.
Create an account or sign in to comment