MS ACCESS MAILING LIST: [belajar-access] Re: mau tanya update query

Silakan download
[mau tanya update query no29101 versi 1.rar]
[mau tanya update query no29101 versi 2.rar]
[mau tanya update query no29101 versi 3.rar]

di [Files] [jkssbma] [cobasolusi] [Query Update]

versi 1 :
menambahkan nilai data table1 pada table2
versi 2
mengganti nilai data table2 dengan table1 ( belum menambahkan
record yang belum ada pada table2 ).
versi 3
selain versi 2 , ada penambahan record data.

****
** saya kutip sebagian dari pesan no 29117
******

Salam sejahtera

--- In belajar-access@yahoogroups.com, Rusmanto <rusmanto@...> wrote:
>
> Assalamuallaikum,
>
> Teman-teman saya mau tanya gimana caranya update data yang sudah ada dengan data baru yang field nya sama persis,
> seperti contoh di bawah ini :
>
> Saya mau update Tabel1 dengan Tabel2.
> saya sudah coba import tabel tapi tidak mau, tetap aja nilainya tidak berubah.
>
>
> Tabel1.
>
>
> sample_id au1 au2 au3 au4 ag1 hg1 auave agave
> 1011260 0.25 5.2 1.2 0 2.725 1.2
> 1011296 0.25 5.2 7.8 0 2.725 7.8
> 1011469 0.25 5.2 1.5 0 2.725 1.5
> 1011504 0.25 5.2 5.2 0 2.725 5.2
> 1011512 0.25 0.4 0 0.25 0.4
> 1011678 0.25 0.4 0 0.25 0.4
>
>
>
> Tabel2.
>
>
> sample_id au1 au2 au3 au4 ag1 hg1 auave agave
> 1011260 3.25 3.32 1.2 0.25 3.285 1.2
> 1011296 7.11 7.03 7.8 0.18 7.07 7.8
> 1011469 0.88 0.89 1.5 0.75 0.885 1.5
> 1011504 2.48 2.45 5.2 0.88 2.465 5.2
> 1011512 0.06 0.4 0.09 0.06 0.4
> 1011678 0.31 0.4 0.06 0.31 0.4
>
>
>
>
>
>
>
>
> Mohon pencerahannya gimana caranya yang paling mudah, kalau cuma 5 data sih gampang tapi kalau ada ratusan dan jadi masalah.
>
> terimakasih sebelumnya.
>
> wassalam
> Rusman
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *** This e-mail and attachments it might contains has passed internal anti-virus check but it is suggested for you to re-scan with your anti-virus ***
>
> Disclaimer Notice :
> This message and any attachment contains information intended only for the use of the addresee named above. It may also be confidential and/or privileged.
> If you are not the intended recipient of this message you are herby notified that you must not disseminate, copy or take any action in reliance on it. Please delete the message and notify the sender.
> Opinions, conclusions and other information in this message that do not relate to the official business of Archipelago Resources Plc., Archipelago Resources Pty Ltd.,
> PT Meares Soputan Mining, PT Tambang Tondano Nusajaya shall be understood as neither given nor endorsed by them.
>