Hello, when I use MS Query to retrieve data from MS SQL Server 2005, the data is returned in a table format. The table format doesn't allow for subtotalling. (A simple example would be to retrieve sales figures for a time period, and then create a subtotal for each sales rep and then create subtotals for each customer within each rep.)
When I convert the table to a range, Excel tells me that it will permanently remove the query. Removing the query makes it a one-time use only file. I'd like to retain the query so that it could be refreshed periodically to update the report.
Is there a way to retrieve data from a database and do subtotals without losing the query?

Thanks