Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I sort the information returned from a query?
I use MS Query in Excel. On some of my queries I need to sort a portion of
the returned data in a different order than what the query is built for. Use to be easy in Excel 2003, but the new Excel version returnes the query data in some table format with filters automatically turned on, and if you try to sort a portion of the data, you get all of the data sorted - not just the portion you want. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I sort the information returned from a query?
Highlight the rows you want to sort, then use your sort option.
"Fortarel" wrote: I use MS Query in Excel. On some of my queries I need to sort a portion of the returned data in a different order than what the query is built for. Use to be easy in Excel 2003, but the new Excel version returnes the query data in some table format with filters automatically turned on, and if you try to sort a portion of the data, you get all of the data sorted - not just the portion you want. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I sort the information returned from a query?
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples. -- Don Guillett Microsoft MVP Excel SalesAid Software "Fortarel" wrote in message ... I use MS Query in Excel. On some of my queries I need to sort a portion of the returned data in a different order than what the query is built for. Use to be easy in Excel 2003, but the new Excel version returnes the query data in some table format with filters automatically turned on, and if you try to sort a portion of the data, you get all of the data sorted - not just the portion you want. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query returned more data than will fit on a worksheet | Excel Worksheet Functions | |||
Copying information returned by using Sub Totals | Excel Discussion (Misc queries) | |||
Query returned more data than will fit on a worksheet | Excel Discussion (Misc queries) | |||
This query returned no data | Excel Worksheet Functions | |||
Waiting for data to be returned from Microsoft Query | Excel Discussion (Misc queries) |