Puzzling Problems

[znibk]

have tried over and over again, various combinations, names and placements
for these two problems, but am unable to come up with the correct answer. I
once again hope there is someone out there who can help me.

I am trying to achieve the Yearly Bank Balance. I have, a report in which I
first have a Beginning Balance Bank Header, nothing is in it expcept the bank
name.

In the detail section, I have the beginning balance. [Abegbal] Added to that
detail section, I have sub_report_income_yearly in which I have a text box
with the name TxtTotalAssets and a Control Source of =[Abegbal]+[txtincsum].
I get the total I need when I run the report.

Also in the detail section, I have subrpt_expense_yearly. In this
sub-report, I have a total expense. Name [TxtExpenseSum] Control Source
=Sum([CkAmt]) Again, I get the total I need when I run the report.

When I first started a smaller version of this project, I was instructed to
put in the detail section: two text boxes, one containing
=iif([sub_report_expense_yearly].[report].[has
data].[sub_report_expense_yearly].[txtExpenseSum],0) and another with
=iif[sub_report_income_yearly].report.[has data].[txttotalassets],0])

To obtain the ending balance, I have placed the following in both the
bankfooter and in the report footer. In neither, do I get the result I
desire.

I seem to have two problems. The one stated aboveof not getting the desired
answer, but also the label to the txt box keeps yeilding the name
TxtExpenseSum rather than the name I gave to the result, TxtAEndBal.

In the Text Box, I have the Name TxtAEndBal and Control Source of
=([txttotalassets]-txtexpensesum.

I also know how to show a negative balance, in the event we ever have one.

I hope I have written my question so that you can understand it and I await
with a humble heart and mind, for help with this problem.

You all have been so great to help me out in the past, so I hope you can
help me with these problems.

Thank you and God Bless,

K