Filter and Sort in Access 2010 - trying to filter columns in descendin 1

[CJSwed]

Gentlemen,
Good afternoon. I just upgraded to 2010 Access although this is more of a question for access in general. I am trying to filter columns in a table in descending order independent of each other.

For example:
Column A    Column B
100            95   
90             80
80             70

Is there such a way to accomplish this? To have both column A sorted in true descending order as well as column B truly sorted in descending order.

Thank you to any assistance you can provide...

Chris

 

[CJSwed]

Sorry.. I shouldn't of said filter, I am trying to sort each column in true descending order.

 

[MajP]

You will have to explain the big picture, because it makes no sense in relation to a database, therefore databases not really designed to do that. You may have bigger problems with your design.

Records (rows) have related information. So sorting independently would be illogical.

 

[dhookom]

Gotta love the logic and simple explanation of MajP's reply. Couldn't have said it better.

Duane
Hook'D on Access
MS Access MVP