Ms access calculated field not updating

Or store the hours and total and calc the hourly rate if needed.How do you get Access to store the result of a calculation?It can be simplified to this: =Nz(Sum([amount]),0) But that is irrelevant.

ms access calculated field not updating-54ms access calculated field not updating-89ms access calculated field not updating-61

For example, if you have fields named Quantity and Unit Price, how do you get Access to write Quantity * Unit Price to another field called Amount? " Calculated columns are part of life on a spreadsheet, but do not belong in a database table.

Never store a value that is dependent on other fields: it's a basic rule of normalization.

Generally storing calculated fields is considered a no-no, ref Allen Browne's page on calculated fields.

On this page Allen gives some tips on calculated fields that may help, especially if you decide you do want to store it and use Access 2010 (I'm only on 2007...).

We recommend you use queries for calculated fields, just as in previous versions.

I have an update problem on a field in a main form because that field needs 2 other fields to update before it can be refreshed and display the correct answer. I have a main form with 2 sub forms on the main form. I have tried me.requery, Me.recalc, Me.refresh and some times these work but ofteen I have to move to the next record and then return to this record to get a correct value. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

You will also find it makes your database useless for anyone who needs to use it in Access 2007.

Instead of reading the data, they will get a message like this: Even more serious, the calculated results are not reliable.

Company Bond Total =DSum("[BONDAMOUNT]","bbon NY] and [Status]=1 ") This field just sumarizes the bond amounts into a field. [Companl]) Problem: The sub forms update properly but the "Amt Remaining " field on the main form usually indicates #Error because it updates quicker then the other 2 fields Question: How can I delay the time for this to update so that the other 2 fields update first? I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing.

Tags: , ,