Updating Table

[mfuada]

Hey guys.. i just joining this forum, cause i'm new with access and i hope i can get some help .
My problem is... Right now i'm working on 3 tables
table a with field value_a
table b with field value_b
table c with field tot_value_a,tot_value_b,and total_value

and i would like to update the total sum of value_a in tot_value_a, total sum of value_b in total_value_b without adding new row in the table...
so my question is what should i do to get an update for table c, should this be done in query or vba? could u guys give me some of the example of the code?

Thanks...

 

[pbaldy]

Welcome to the site. It would violate normalization rules to store the totals, particularly since they're so easy to calculate on the fly. You could do it with an update query, but it would be a big mistake. Use a totals query or DSum to get the totals at any time.

 

[mfuada]

Thx for the quick answer, so what u're saying is, don't store the total in the table,since we can update it anytime, is that correct? My intention to store the total in a table is to use it in a report... if the total is not store in a table, can a report display it?

Thx

 

[boblarson]

Thx for the quick answer, so what u're saying is, don't store the total in the table,since we can update it anytime, is that correct? My intention to store the total in a table is to use it in a report... if the total is not store in a table, can a report display it?

Thx

That is what QUERIES are for. Queries can be used just like a table for the basis of a report. If you aren't sure how to use them, perhaps a quick read about them will help:
http://www.functionx.com/access2003/Lesson17.htm

 

[mfuada]

Okey thx a lot i will try it......