Checkbook Register

[denileigh]

I am trying to create a running sum for a checkbook register and I have searched, read, downloaded samples and I'l still at a loss.

Do I create an unbound textbox on the form? What do I put in it? A running sum for Credit-Debit?

Can anyone help?

Thanks!

 

[mike7]

Also very interrested

I'm also very interested in this issue. Can someone respond to denileigh ?

Thanks,

Mike

 

[Rich]

The easiest way is to use a Report, however it can be done on a form if you have a sequential key field. Do you?

 

[denileigh]

You mean an ID? Yes - I do.

 

[danielgarretty]

you could do it if you had your credit / debit in the same column/field, and inserted your debit in negative numbers.

Example Column Name: Credit/Debit
Example Table Name: Chequebook Register

1. Create A New Form In Design View
2. Insert A Text Box
3. In The Control Source Enter:

=DSum("[Credit/Debit]","Chequebook Register")

I think that should work

 

[mike7]

What if....

What if you have two separate tables.

One called ''Revenus'' that increases the bank account (or a credit) and one called ''Expenses'' that decreases it....

How would you do it this time ?

Mike

 

[danielgarretty]

Example Table Name: Credit
Example Field Name: Credit1

Example Table Name: Debit
Example Field Name: Debit1


1. Create A New Form In Design View
2. Insert A Text Box (Example Name:Text1)
3. In The Control Source Enter:

=DSum("[Credit1]","Credit")

4. Insert Another Text Box (Example Name: Text2)
5. In The Control Source Enter:

=DSum("[Debit1]","Debit")

6. Insert a Third Text Box
7. In The Control Source Enter:

=[Text1]-[Text2]

Note:
its the third text box that gives you your running total.

To hide the 1st and 2nd text boxes, open their properties and set visable to no.