update/append query?

[Guest]

now i got a table(name= inv) with
inv client total
01 0001
02 0003

n then i got a query(name =total) which help me to devive the total for each
inv (calculated from 2 sub tables)
inv sum
01 HK$100.00
02 HK$190.00

so how could i use an update/append query to update my orginal table with
the amounts calculated in the query at the correct places?
that is to produce this inv table
inv client total
01 0001 HK$100.00
02 0003 HK$90.00

 

[John Vinson]

now i got a table(name= inv) with
inv client total
01 0001
02 0003

n then i got a query(name =total) which help me to devive the total for each
inv (calculated from 2 sub tables)
inv sum
01 HK$100.00
02 HK$190.00

so how could i use an update/append query to update my orginal table with
the amounts calculated in the query at the correct places?
that is to produce this inv table
inv client total
01 0001 HK$100.00
02 0003 HK$90.00

Orek, you've asked this question at least five times in five different
newsgroups. You've gotten several answers.

Are you not seeing them, or just deliberately ignoring them?

John W. Vinson[MVP]

 

[Guest]

o. it because my computer kept telling me my post cannot be posted into the
board due to some connection error, and ask me to post again.
sorry for all the fuss caused.

n thx for ur answer.