3 sorts on one table

[Rick_W_Johnson_(Guest)]

I need to do a report with 9 columns. The first three columns come__from a table (A) with the index set to one of the fields in the table.__The second three columns come from the same table(A) but sorted on a different field, and the third 3 columns are again from the same table(A) but sorted on a third field in the table(A). The fields in the three columms are the same, just each group of three is presented in a different order.____Thanks in advance__Rick Johnson____dBase tables__R&R 9 with all updates__NT 4.0 with all patches

[kfleming]

So it would be the same set of records but each section sorted a different way? So if I had a database of 10 people the first columns would show the list sorted by first name, the second by last name and the third by date of birth for example?____If that is the required design, I cannot think of an easy way to get there other than doing an export to excel and then doing the column sorting there.____Kathleen__R&R Support

[Rick_W_Johnson_(Guest)]

YOur example is correct. Thanks for the thought. I guess I was looking for some way to "alias" the table differently. I guess I will just "clone" the database twice just before running the report. Was trying not to do that. Thanks again.____Rick