Help...Sums....

[vlmullenger]

Hi There,

Can someone help me please...I have built a database to keep a track of my clients and payments.

I am now on the accounts tab and would like to have the following:

Date
Description
Member Of Staff
Credit
Debit
Total

I would like to link the final three together to keep a running total..so if I put in one day Credit 100 and the following week a Debit of 80 the total would read as 20. How do I do this?

Thanks

Vicky

 

[Alane]

In the "on entry" option in properties for your Total add the vb code to set Total = Credit + Total

 

[vlmullenger]

Sorry Im lost....

I have right clicked on total and clicked propertys...and clicked 'all' and cant see data entry...

Thanks

 

[oumahexi]

In the control source for your total you could try something like:
Me!Total = Credit - Debit

If this doesn't work, try moving it down to the vb code as Alane suggested. If you look in the Event Tab you'll find a list of options, one of them is On Enter, if you click in the row for that you will see the ... option that takes you to your VB code for the event.

 

[vlmullenger]

Hi There,

It is not working...but I have just thought of something that I need to do first in order for it to work properly.

I currently have one row of table entrys, and I am going to need this to be an ongoing sheet like on excel in a table...How do I do this first?

Sorry I am new at this and am hoping there is an easy way to do what i need to...

Thanks

 

[boblarson]

You should not be trying to store the total (at least not until Access 2010), as Access does not currently have triggers. You store the two values from which the total is calculated in a query. If you store the data, it runs a high risk of being WRONG, if someone makes a change inside the table itself as there is currently no mechanism available to synch the total if a change at table, or query, level is made.

 

[vlmullenger]

Ok...makes sense!

How do I do this???

Thanks

 

[boblarson]

---deleted post because it was completely incorrect ----

 

[Rich]

Do you have a sequential key and a date field?