Update table MS Access 2003

[riagil]

Dear, Access Master
I have 2 table tmpinduk and peminjaman:
tmpinduk :


----------------------------------------------------------------
induk | jdl_buku | pengarang | penerbit |jml_buku |status |
----------------------------------------------------------------
144 | Cerita Rakyat | Iskandar | Bondan | 2 | 0 |
155 | Naruto Komik | Masashi | Elexmedia | 0 | 0 |
156 | Bleach Komik | Masashi | Elexmedia | 1 | 0 |
177 | Teori Pembangunan | Mulyanto | UI-PRESS | 0 | 0 |
179 | Ensiklopedia Hewan | - | Gramedia | 2 | 0 |
180 | Ensiklopedia Tumbuhan | - | Gramedia | 1 | 0 |
181 | Teknologi | Zoomkobe | Ganeca | 2 | 0 |
182 | Baskeball Fundamental | Phil Jackson | Elexmedia | 1 | 0 |

peminjaman :
-----------------------------------------------------------------
| mulai | kembali | nis |induk | jml_buku | denda | status |
-----------------------------------------------------------------
16/8/2010 | 18/8/2010 | 6325 | 155 | 3 | 0 | 0 |
16/8/2010 | 18/8/2010 | 6325 | 156 | 2 | 0 | 0 |
16/8/2010 | 18/8/2010 | 6464 | 144 | 1 | 0 | 0 |
16/8/2010 | 18/8/2010 | 6464 | 177 | 1 | 0 | 0 |

The question is, how to update tables on a column tmpinduk jml_buku like this, (tmpinduk.jml_buku + peminjaman.jml_buku), and I imagine the result is :

tmpinduk :
----------------------------------------------------------------
induk | jdl_buku | pengarang | penerbit |jml_buku |status |
----------------------------------------------------------------
144 | Cerita Rakyat | Iskandar | Bondan | 3 | 0 |
155 | Naruto Komik | Masashi | Elexmedia | 3 | 0 |
156 | Bleach Komik | Masashi | Elexmedia | 3 | 0 |
177 | Teori Pembangunan | Mulyanto | UI-PRESS | 1 | 0 |
179 | Ensiklopedia Hewan | - | Gramedia | 2 | 0 |
180 | Ensiklopedia Tumbuhan | - | Gramedia | 1 | 0 |
181 | Teknologi | Zoomkobe | Ganeca | 2 | 0 |
182 | Baskeball Fundamental | Phil Jackson | Elexmedia | 1 | 0 |

I get an error message "syntax error (missing operator) in query expression, t.jml_buku + p.jml_buku from tmpinduk as t join peminjaman as p on p.induk = t.induk ",
if I using this query :

update t set t.jml_buku = t.jml_buku + p.jml_buku from tmpinduk as t join peminjaman as p on p.induk = t.induk

in MsSQL Server this query have no problems...
thanks before, for all your help.....

[maximus]

This is a small example that I have posted. I have used a Update Query to update tbltech which has a relation with table ccc. I have concatenated ccc.tname and ccc.tdetails and used it to update tbltech.tname.

UPDATE tbltech INNER JOIN ccc ON tbltech.techid = ccc.techid SET tbltech.tname = [ccc].[tname]+" "+[ccc].[tdetails];

[riagil]

thank you maximus, but I have a problem with it..

I try this :

UPDATE peminjaman AS p INNER JOIN tmpinduk AS t ON p.induk=t.Induk
SET t.jml_buku = t.jml_buku+p.jml_buku
WHERE t.induk IN(select induk from peminjaman where nis=4646 and status=0);

the result is wrong, this sql result : do you want to update 4 record?
This not what I want, I want to update only record with nis=4646,,

this : SET t.jml_buku = t.jml_buku+p.jml_buku
is calculate all without see WHERE statement.

I'm sorry with my English...