form/query to update table?

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

Guest

Hello there,

This may or may not be a silly question and might potentially be posted in
the wrong area but i think it belongs here....

I have a query that sums a few columns from a table. I want this sum to be
updated in the main database table but at the moment it is not updating the
table. The "Sum" column in the table remains filled with zeros... The sum
calculation in the query seems to be working and gives the correct value in
the query. I also have a form that uses the query and the correct values
show up in the form.

Does anyone have any ideas on why the values are not being transferred back
to the tables?

Any help would be greatly appreciated,
Terrel
 
Hello there,

This may or may not be a silly question and might potentially be posted in
the wrong area but i think it belongs here....

I have a query that sums a few columns from a table. I want this sum to be
updated in the main database table but at the moment it is not updating the
table. The "Sum" column in the table remains filled with zeros... The sum
calculation in the query seems to be working and gives the correct value in
the query. I also have a form that uses the query and the correct values
show up in the form.

Does anyone have any ideas on why the values are not being transferred back
to the tables?

Any help would be greatly appreciated,
Terrel
Click to expand...

Don't store calculated data in your table!
Store just the underlying data.
Any time you need the sum of the data, simply re-calculate it (as you
are doing now), in a query, on a form, or in a report.
 
Thanks.

Will keep it in queries.. hehe

fredg said:
Don't store calculated data in your table!
Store just the underlying data.
Any time you need the sum of the data, simply re-calculate it (as you
are doing now), in a query, on a form, or in a report.
Click to expand...
 
Back
Top