Totals of some sums???? 1

[sandora]

Ver 11, Access DB - Making a Balance Sheet. Here is what I have:

(GH1) Assets
(GF2) Cash 644,807
AR 573,803
Etc...
(GF1) Total 21,161,638

(GH1) Liabilities
(GF2) AP 175,996
Acc.Liab 209,639
Etc...
(GF1) Total 23,018,646

(GH1) Equity
(GF2) Beg Capital 1,000
(GF1) Total 1,000
(RFa) RetEarnings (1,858,007)
(RFb) Total Equity (1,857,007)

Total Liabilities & Equity 1,000

Obviously Total Liab and Equity isn't correct. I can't get total liabilities and total equity to add together. I tried this formula:

if {@AcctCat} in ["Liabilites","Equity"]

then Sum ({@Total Acct#}, {@AcctCat})

without success. If this is not enough info please let me know.

 

[synapsevampire]

Since you don't share what's in your formulas, it's hard to state exactly what to do.

You might be able to just use a Running Total of your formula and in the Evaluate->Use a Formula place:

{@AcctCat} in ["Liabilites","Equity"]

Or create a formula in the group footer to create a sum which has:

whileprintingrecords;
numbervar MySum;
if {@AcctCat} in ["Liabilites","Equity"]
MySum:=MySum+{@formula}

then display it at the report footer using:

whileprintingrecords;
numbervar MySum;

-k