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!!
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!!