Report - Grand Total needed 1

[cbearden]

I am totaling all cost for different dealers. I have now 4 different categories.

The way I have it now is: Each dealer has at least one acct, Each category is added up for each account giving me a total cost of the dealer for that category. But I am needing the 4 categories to be added up rather than the 4 individually.

Can someone help. Thanks

Ex:

Dealer Total # Cat #1 Cat #2 Cat #3
Dlr 1 3 accts $1000 $200 $4500
Dlr 2 2 accts $300 $500 $3000

I am trying to get those 3 added together. Right now, they contain the total cost for the 3 accts.

 

[psemianonymous]

I honestly recommend you do some query magic and in the query designer, do something like:

TOTAL: Nz([Cat #1]) + Nz([Cat #2]) + Nz([Cat #3]) + Nz([Cat #4])


And then take the 'grand sum' of the total in the report. There's another way to accomplish the same thing in the report, but I think putting it in the query is cleaner.

Also note that you may have to include the original tablename so replace [Cat #1] with [Tablename]![Cat #1] or if in doubt use the expression builder and 'pull in' the field.