update/append query?

O

orek

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
 
J

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]
 
O

orek

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

update query 1
update query? 0
Relationships in querries 1
Append Query 3
Complex query 4
Select / Append Query 1
Adding prompt responses as as a field value 3
Rounding in Update Query 3

Top