Moving Columns Automatically in Query

[OU18]

All,
Is it possible to move the columns in a query based on some criteria.

Example,
If I want the column with the lowest digit to appear as the first column, and the second lowest as the second column, etc.

This would change each time the query is run due to different rows having different numbers in each column.

Thanks

 

[dhookom]

This is an odd request that should probably be backed up with some sample data and desired result/output. Please take the time to provide this information.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[PHV]

Perhaps a cross-tab (pivot) query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244