How to read last record using VBA?

[chuki2]

Hello there....i need a help...

I need to create finance system,

On table,i have name,memo,credit,debit and balance



So when i put new record,it will read [balance] last record before to plus or minus and save it....

Any idea?

[aytee111]

This type of value should not be kept on a table as it is a calculated field and changes all the time. Whenever you need it, recalculate it - whether for forms or reports. I would suggest keeping a permanent query which calculates it correctly and whenever you need to display the value you can reference the query.

[chuki2]

Hmmmm i see...

If i have 3 table,how to calculate it? need make relationship?

[aytee111]

I think the credit and debit amounts are both on one table? Thus it would be a simple query to total and subtract one from the other.

If it is more complicated than that, tell me what your formula looks like.

[chuki2]

Yup that right....credit and debit both on one table...

Ok here,i have 2 table....one called tblCustomer,tblAccountingCustommer and tblOfficeAcount

tblCustomer is link to tblAccountingCustomer and tblOfficeAccount

So when customer make payment,it will save to tblAccountingCustomer for record and tblOfficeAccount for debit...

Let say column on tblOfficeAccount have debit,credit,date and time and balance

So if in query? how i can calculated?

And if customer make payment,how i can read last balance on tblOfficeAccounting to plus on balance?

I hope you understand... Thank you so much my friends...

[aytee111]

I'm not sure I do understand!

Your query can link tblCustomer and tblOfficeAccount, then using the Totals you can Sum the debit and credit amounts and you can also sum them together to get the balance. Do not try and keep the balance on the tables anywhere.

[chuki2]

Hrmm.... i still can`t imagine...hehe..

Is ok,i will try my best...if anything problem,i will ask again...thanks for help my friends...

[chuki2]

****************************
| debit | kredit | remaining |
****************************
| $230 | $0 | $230 |
| $0 | $120 | $110 |

Look like this....hehe,can u imagine?

So if in query? what formula i need to create?