Adding Columns of two tables (2 Viewers)

rahultiwari

Registered User.
Local time
Today, 13:07
Joined
Jan 30, 2005
Messages
21
Hi..I have three tables A ,B and C, which have fields A,B and C respectively.
I want to do that following default calulation

A.a=B.b+C.c
meaning adding two columns of different tables and storing it in a third column.
It works for me in the forms but I want to do that in the table.
Is there any way to go about it


Regards
Rahul
 

neileg

AWF VIP
Local time
Today, 19:07
Joined
Dec 4, 2002
Messages
5,975
Do it with an update query.

However, storing a value that can be calculated anytime you need it is bad design. In general, I would only do this if the values of B & C may change, and that the value of A at that point in time is important. An example might be storing invoice values based on a price table that gets updated with new prices.
 

Users who are viewing this thread

Top Bottom