sum of different fields in a report

[Nelson]

Hello,
I'm trying to learn how to use MS Access by using my EBay transactions
as the source of my data. Right now I'm in the process of creating a
report that shows my net proceeds based on gross sales minus EBay fees.
I'm having trouble coming up with a grand total of all of my fees. I
have a table called EBayFees that has all of the different fees broken
down by category. For instance, there are fields entitled
"InsertFees", "FinalFees", "PictureFees", etc. In my report, I would
like to sum all of these different fees into one text box labeled
"TotalEBayFees". I can't figure out how to do it. Any suggestions?
Thanks.

 

[Duane Hookom]

If all you fields are valued (not null) you can total across a record with
an expression like:
=FieldA+FieldB+FieldC
To sum these values in a group header or footer, you can use:
=Sum(FieldA+FieldB+FieldC)
If you might have Null values, you must wrap your fields in Nz(FieldName,0).