Help adding up fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table Basline Termination form
it has
InterviewID and CO_022, CO_032, CO_042.... as fields
and a new field Multipules_found

What I need to do is add up all the CO_'s and put the result of the sum
into Multipules_found of each InterviewID.
What is the best way to go about this?
 
You don't!

That would be "storing a calculated field" and it is not normally done in
Access. You would, instead, add an unbound field to your queries, forms, or
reports withsomething like...

= [CO_022] + [CO_032] + [CO_042]
 
OK so if I were to create a query how would I do this? Then can this be
stored in the table or not?

Rick B said:
You don't!

That would be "storing a calculated field" and it is not normally done in
Access. You would, instead, add an unbound field to your queries, forms, or
reports withsomething like...

= [CO_022] + [CO_032] + [CO_042]



--
Rick B



pokdbz said:
I have a table Basline Termination form
it has
InterviewID and CO_022, CO_032, CO_042.... as fields
and a new field Multipules_found

What I need to do is add up all the CO_'s and put the result of the sum
into Multipules_found of each InterviewID.
What is the best way to go about this?
Click to expand...
Click to expand...
 
In a query, you'd add a new field/column with...

SomeNewName: [CO_022] + [CO_032] + [CO_042]


Again, no, you don't store it in a table. When you need it, calculate it.
Storing it would never work. What if one of the values changes? How would
Access know to go back and fix the calculated value?


--
Rick B



pokdbz said:
OK so if I were to create a query how would I do this? Then can this be
stored in the table or not?

Rick B said:
You don't!

That would be "storing a calculated field" and it is not normally done in
Access. You would, instead, add an unbound field to your queries, forms, or
reports withsomething like...

= [CO_022] + [CO_032] + [CO_042]



--
Rick B



pokdbz said:
I have a table Basline Termination form
it has
InterviewID and CO_022, CO_032, CO_042.... as fields
and a new field Multipules_found

What I need to do is add up all the CO_'s and put the result of the sum
into Multipules_found of each InterviewID.
What is the best way to go about this?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top