How do you add the last balance in a text box

[princessdmb]

Hello,

I need help with my report.

My report(detail section) displays the running balance, the report footer calculates the sum per colunm, and i will like to add a text box the displays below the running balance the last balance as the total balance. If you open report, enter 1 as the parementer and go to second page.

Please help me

 

[KenHigg]

Can you just put a text box in the footer the sums the UAP Bal?

 

[vbaInet]

1. Open up your "UAP Report filter qry" query in design view.
2. Add UAPBalance: IIf(([Month/Year]<#01/04/2000#),([grant]-[current recoup]-[arrears recoup]+[other]),([grant]-[disregard]-[current recoup]-[arrears recoup]+[other])) as a new column in the query.
3. In the Control Source of the UAP Bal textbox of your report, select UAPBalance.
4. Perform the Sum on UAPBalance.

The rule is you can't perform totals on a calculated field. The field must exist as a field in the report's Record Source.

 

[KenHigg]

I think UAP Bal is in the query...

 

[vbaInet]

I think UAP Bal is in the query...

I'm looking at the query now, it's not there.

 

[KenHigg]

hum... I got the sum() on that textbox to work in the footer

 

[vbaInet]

Can we see the expression you used? Or could you please upload the db?

 

[KenHigg]

See attached

 

[vbaInet]

Ah, alright. I see where you misunderstood the problem. It's a report issue, the report is called "Report by Case#1".

 

[KenHigg]

Oh, my bad... Looks like you have the issue figured out so I'll bow out

 

[vbaInet]

Your comments are always welcome I see you've been here for a very long time

 

[KenHigg]

Your comments are always welcome I see you've been here for a very long time

Yeah, been away for a while

 

[princessdmb]

Hello,

Well i tried using the UAPBalance: IIf(([Month/Year]<#4/1/2000#),([grant]-[current recoup]-[arrears recoup]+[other]),([grant]-[disregard]-[current recoup]-[arrears recoup]+[other])) to the UAP Report filter qry, and updated the UAP Bal text box properties. The balance is not showing. See attach image, the last balance shows $12,029.71 and the total balance below reads $259.00. I will like to see the $12,023.71 as the total balance not $259.00

Please help me

 

[vbaInet]

Oh yes, I overlooked the fact that you were cumulating the values. See attached and have a look at the code.