If you want to email me the Database, I can take a look at it. My address is Mark A Sam Att M S N Dott Comm Remove the spaces, change Att to @ Dott to . and Comm to com. I think you understand why. Also change the database extension from .mdb to .mdx. I'll rename it when I get it. Otherwise I can't save it to my drive. God Bless, Mark "Gwendolyn" <Gwendolyn@discussions

I will definitely try this Mark! I'll let you know how it goes. God bless you richly! -- Gwendolyn "Mark A. Sam" wrote: It would help if you talked about tables instead of forms. I think you created the subform using the original table. If you have a form and subform, you need a table for each. From your description, the main table should have these fields:

Hi Mark, Would it help if I explained it further? Original form (used for past 6 months) called Transactions TransactionID TransactionDate TransactionDescription ReferenceType Number AccountID ExpenseType WithdrawlAmount DepositAmount DonationSource MissionsDepartment Then I created a subform using the AccountID - MissionsDepartment and inserted it into the old Transaction

You're welcome, you're welcome:) "Charles" <Charles@discussions.microsoft.com> wrote in message news:034F3400-A105-4549-8204-C58627E12B3C@microsoft.com... This answer from Pat Hartment solved 2 days of looking for an answer. Thank you thank you. -- cjw "Pat Hartman (MVP)" wrote: The problem is probably caused because some rows have null values in DepositAmount

The problem is probably caused because some rows have null values in DepositAmount or WithdrawalAmount. Duane's solution works because the aggregate functions ignore nulls so sum(aa) - sum(bb) will work fine. In other situations you may have to use the Nz() function --> sum(Nz(aa,0) - Nz(bb,0)) -- notice that each operand in the expression must be cleaned of nulls. Nz(Sum(aa - bb)) will