Calculating Column Totals

[MiTortuga]

I have a table with revenue by contract imported from crystal reports. This data is then thrown in a query to match the contract with the corresponding account rep. The query is set to prompt the end user to enter the account rep name so that only revenue (and related data) is shown for that specific account rep. All that works great. My problem is that I need to show column totals by account rep in the query so that it can be exported to excel and emailed to each individual account rep on a weekly basis. Can someone please help me?

I appreciate any advice!

 

[neileg]

The only way I can think of doing it in Access is to create your select query for the rep, create a totals query based on the same data and then union the two queries together. Export your unioned data to Excel.

You could probably do it in Excel by querying the data in Access and adding the totals in a macro. In fact, as your manipulation seems so simple, I think you could do the whole thing in Excel with a combination of VLOOKUP and a pivot table