Calculated field plus previous record

  • Thread starter Thread starter Kon
  • Start date Start date
K

Kon

I have a debit and a credit and I want a calculated field named residual
(debit - credit). The field residual I want to be (credit-debit)+residual
previous record. How can I do this.
(I tried a custom function using form.recordset but I couldn't use it
because every time I go to next
record recalculated the residual and and mixed up. Any suggestions or any
code in web site?
 
Kon said:
I have a debit and a credit and I want a calculated field named residual
(debit - credit). The field residual I want to be (credit-debit)+residual
previous record. How can I do this.
(I tried a custom function using form.recordset but I couldn't use it
because every time I go to next
record recalculated the residual and and mixed up. Any suggestions or any
code in web site?
Click to expand...

Unless I'm missing something, surely for any given record the residual is
simply the sum of debits and credits on ALL of the records? If you want to
display this in a form, you could use Dsum:

=DSum("[debit]-[credit]", "my_table")
 

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

Similar Threads

How do I calculate a total from a continuous form? 1
Enter Parameter Value - Custom Calculation In Report 2
Make controls not visible if is not null field 4
How do I query a calculated control? 1
Populating Values from one form to another 2
Duplicate record selection 1
Simple Question on Addition 3
Cumulative Total in a Query 1

Back
Top