Totals Question

[trish.martins1984]

I used simple query wizard to do a query. I sum both fees and discount columns, but how do I total them together?

Sorry, kinda new at this!

thank you in advance for you help!

 

[Katy]

If your data is coming from one table, I assume that you have simply selected both those fields and added the sum function into the totals row of the query so you end up with two columns SumofFees and SumofDiscounts. If you add a third column to the query and in the field row write: Total:[Fees]+[Discounts] and ensure that it also has Sum in the totals row, it should give the overall total.