I have three columns product1 and prodcut2 and amount. i want that in amount columns the sum of pro1 and pro2 should add. should i slect query in mdb database 2000.
Printable View
I have three columns product1 and prodcut2 and amount. i want that in amount columns the sum of pro1 and pro2 should add. should i slect query in mdb database 2000.
CONNECT the database via vb and u can update all the record of the amout with the sum of both the field....
Why?Quote:
Originally Posted by vivek_master146
Storing calculated answers is a waste of database space. You don't need the amount field if the contents that would be stored in it is ALWAYS the sum of the other two fields.
When you retrieve data on product1 one and product2 two, programmtically do the calculations then, on the fly, and do whatever you need with the result.
@ vivek i think that hack is correct
I know that i can do it by getting the values. but is there a way to do that.