O
orek
is there a way in which i could insert or update a field in a table using a
value calcuated in a query to an existing row in the table?
now in one of my table i got
inv client total
01 0001
02 0003
in a query
inv sum
01 HK$100.00
02 HK$190.00
and i want to insert the sum of the query to the total in table to create
inv client total
01 0001 HK$100.00
02 0003 HK$190.00
value calcuated in a query to an existing row in the table?
now in one of my table i got
inv client total
01 0001
02 0003
in a query
inv sum
01 HK$100.00
02 HK$190.00
and i want to insert the sum of the query to the total in table to create
inv client total
01 0001 HK$100.00
02 0003 HK$190.00