Help on Calculations

winedott

New member
Local time
Yesterday, 23:24
Joined
Mar 30, 2009
Messages
9
I know the rules about saving calculations in a table, but I am in need of doing so for historical purposes unless anyone else has another idea that will work for my situation. I have read most of all the other post advising not to.
I am building a DB that needs to calculate 2 fields and store that number in a total field. The total field will then need to accessed on the next record using DLookUp.

This db will be used in a jail setting and will calculate the number of people arrested (BroughtIn) minus the number of prossesed inmates (Booked). This calculation will be place in a field named (Awaiting).

On the next record I need to DLookUp("[Awaiting]" and placed in a field named (Left).

I have tried several things that were mentioned in other post but can get nothing to work. Please keep in mind that I have very new to access and have have little knowledge.

Thanks in advance!!
 
What is the historical reason for storing the calculation? I don't believe you have mentioned it yet. Your difficulty may just be do to the design of the tables.
 

Users who are viewing this thread

Back
Top Bottom