Calculation Result at every entry

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.
 
J

John Vinson

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.

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top