Quote Originally Posted by stanl
Have you considered using the SQL query as data for a Pivot Table - where totals/subtotals are displayed. .02 Stan
Yeah, if you are looking for final ouput that is interactive with the user, then pivot table is the only way to go.

Better to just present ALL the data in an interactive format, then to get variables from the user to customize the SQL string.

EDIT: here is a really good book on SQL basics.

http://www.amazon.com/Sams-Teach-You...dp/0672325675/