>Here is the SQL statement to set up my report
>
>SELECT SUM(General_expense_account.eamount),;
> General_expense_account.etype,
> General_expense_account.maincategory;
> FROM churchdata!general_expense_account;
> GROUP BY General_expense_account.etype,;
> General_expense_account.maincategory;
> InTo Cursor MyieCursor
> *Browse
>REPORT FORM ie_report.frx Preview
>
>My question is how do I get the sum of the maincategory in my report. When I put sum_eamount in the group footer of maincategory it only gives me to last value.
>
>Please Help,
>God Bless,
>S. Dyke


Isn't eamount already the sum of the main category? That's what your group by clause with the sum does. Don't sum your eamount in the rpt.

HTH