I have one report and trying to enter formulas

[mpineda7]

Hello, I am kind of new in MsAccess and I have a report where at the end , I have three boxes, one for Beginning Balance where I just need to enter the value manually but I used a "Text box" and one is showing "unbound" wondering if I need to use a different box?

Second Total has a sum, I am fine with this one, but I need on

Third box a formula adding "Beginning Balance box+ Second box" .

The first box is named as "BegBalance"
Second = "AccessTotalsAmount"
Thrid "Text 20"





Thanks for your help in advance

[rpeare]

Why are you typing in the beginning balance instead of allowing a calculation to figure it out?

If you retain this design change the NAME of the unbound text box to BEGBAL
Change the formula in the text box associated with total activity to =Sum(Amount)
the = sign is not showing and I don't know if that's because it's centered or in error

Change the formula in the text box associated with ending balance to =BegBal + Sum(Amount)

[mpineda7]

Thank you so much for replying quicly.
Well, I have another table which include the beginning balances but because I am naive on this I did not want to deal with pulling a data from another table or using =If-AND-Then , for now I am trying to get these formulas and I will researching more to pulling data from another tables :-).

I did the changes but still it is not showing the totals probably I did something wrong and yes the "=" sign is there so for "Total Activity" I'm okay only trying to enter manually the beginning balance (numeric field) and get the Ending total...

[mpineda7]

I got it :-) but just trying to give a currency form to BEGBAL?

[rpeare]

use

= ccur(begbal)

[mpineda7]

Hi rpeare, after I did the change it didn't ask me for BegBal to enter it manually so was showing me "0" zero. I did a Mask but if I have more millions I will have to change that :-(

Thanks for your time and help!

[rpeare]

make the formula in the text field

=ccur([BeginningBalance])

Leave the NAME of the text field

BegBal