Microsoft's proposed solution is more difficult than manually adding the totals yourself!
I thought at first that it might be possible to do this by adding text like '=SUM(A1:A30)' to the last row in a table, but Excel just treats it as text, I have another theory about how this could be done, it ought to work, but I've not tested it, You could:
-Create a temporary table which has all of the fields that you want in your spreadsheet, plus another field 'Type' (text) - default value 'Data'. And an autonumber field, indexed to preserve the order of the rows.
-Append your data into the table. (the 'type' field will say 'data' for all of these appended rows)
-Run an append query to add another row to the bottom of the temporary table, appending the word 'Total' into the Type field, and append the totals of the columns into their own fields on the 'total' row.
-Export the table as a spreadsheet, it should contain a load of 'data' rows plus a 'total' row at the bottom.
Can you see what I'm saying?
Mike
[This message has been edited by Mike Gurman (edited 08-17-2000).]
[This message has been edited by Mike Gurman (edited 08-17-2000).]
