Update query and add to total

[aaslezak]

I have two tables Summary by project with the fields Project and sum of remaining hours and Estimated hours summary with the fields project and sum of estimated hours. I join them by project number and select them. In the update by on the sum of remaining hours I want to add the estimated hours to the remaining hours and the formula I use is [SumOfRemaining Hours]+[SumOfEstimated Hours] but after the update instead of getting the sum of the two I get blanks. The field names are correct and they are both numeric so why does it not add them up. Is there a different formula to add another value to the current value?

[June7]

Why are you saving aggregate data to table? Normally, detail data is input and aggregate data is calculated when needed.

[aaslezak]

Its all right I figured it out when I put the table names in then it worked. [AMA IT Summary By Project].[SumOfRemaining Hours]+[AMA IT Estimated Summary Hours].[SumOfEstimated Hours]

[JoeM]

As June alluded to, it is usually unnecessary to save anything to a table when it can be derived from a calculation (as matter as fact, it often can cause data integrity issues to do so).

Why do you want to store it in a table, instead of just getting the value from a query calculation?