Calculate sum and percentages in Report or in Query??

[sjh]

I have a report that displays individual values and their sums and the percentages. Is it more efficient/better to calculate the sum and percentage in one query and use that in the report? Or just calculate them directly on the report?

Also, which way is faster?
1) Create temporary tables and use the data from that in another query
OR
2) Create a sub-query, then use the sub-query in another query.

Thanks a lot! - sjh

 

[cheiboy]

I found it easier for me to do my counting/summing in the report by use of the =Count() function.