transferspreadsheet and add a formula ?

[juniormint2009]

I am using the transferspreadsheet to export my query results to an excel sheet. Is it possible to then add a cell at the bottom of the excel rows that sums up 1 of the colums ? Easy enough to do in excel but I would rather have it automated.

 

[PHV]

Can't you export an union query (your actual query UNION an aggregate query doing the math) ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886