Filling a table field with a query result

[MrZimma]

I have a query_ReimburseResult
that counts the yes/no answers in field Reimburse from tbl_Survey.

How do I take the results from the query and put it into a field in another table?

I have tbl_Result and a field called ReimburseResult. I set the type to long integer and then what?

thanks!

 

[MrZimma]

I should add that There are about 10 more fields that I am going to add to the results table. Is it possible to just write an append query that will bring the results from the rest of the queries together in one table?

 

[Pat Hartman]

Normally, calculated values are not stored. This would violate third normal form. Access treats queries and tables interchangably so rather than storing calculated values, you can simply refer to the query that calculates them from another query or from a form or report's ControlSource.