I Think A Simple Question.....?

[logs22]

Here is my question:

I am designing what to me is a reletively complicated database and was wondering if it is possible to use formulas in tables. For example I have opening balances with total debits for the day and total credits for the day. I want to include the closing balance in the same table by simply subtracting the debits and adding the credits to the opening balance. The data is currently in an excel format with very simple formulas embedded. Sounds very easy only i can't figure it out. I am just hoping I do not have to create a query and a seperate table to do this. I would greatly appreciate any help........


Someone in over there head

 

[Jack Cowley]

You can only do calculations in a query, form or report. The second thing is that in Access you do not save 'totals' but calculate them as you need them. So to do what you want you will need a form or query and then you should calculate your balance 'on the fly'...

Probably not what you wanted to hear but Access is rather different than Excel....

hth,
Jack

 

[Rich]

You could of course store the "Audited" balances in another table on a regular basis and limit the data entered/returned based on the Audit dates/amounts

 

[logs22]

Thanks for the answers....That is what I suspected but I was hoping maybe I was wrong because things would have been a lot easier that way. What you said about calculating on the fly makes sense though, I was still thinking in terms of excel rather than access.

Dan

 

[Jack Cowley]

You are welcome. Good luck with your project....

Jack