Calculation Result at every entry

  • Thread starter Thread starter Asim Mahmood
  • Start date Start date
A

Asim Mahmood

please help me in this case i need a Balance entry by
entry in Reports

DebitAmt CreditAmt Balance
1,000.00 0.00 1,000.00
0.00 200.00 800.00
0.00 600.00 200.0
4200.00 0.00 4400.00

how can i get data like this in reports. please send
solution as early as possible.
 
please help me in this case i need a Balance entry by
entry in Reports

DebitAmt CreditAmt Balance
1,000.00 0.00 1,000.00
0.00 200.00 800.00
0.00 600.00 200.0
4200.00 0.00 4400.00

how can i get data like this in reports. please send
solution as early as possible.
Click to expand...

Create a Report based on your table (or on a query).

Put textboxes on the report for DebitAmt and CreditAmt.

Put another textbox on the report and set its Control Source property
to

=[DebitAmt] - [CreditAmt]

View the textbox's Properties and set its Running Sum property to

Over All

if you want the running balance to cover all records in the report, or

Over Group

if you are calculating a balance for each member of a group.

John W. Vinson[MVP]
(no longer chatting for now)
 
Back
Top