---------- Forwarded message ----------
From: "Aksan Kurdin aksan.kurdin@gmail.com [belajar-access]" <belajar-access@yahoogroups.com>
Date: Mar 16, 2015 1:15 AM
Subject: Re: [belajar-access] dua tabel ,jadi satu di query
To: <belajar-access@yahoogroups.com>
Cc:
regards,
a.k.
From: "Aksan Kurdin aksan.kurdin@gmail.com [belajar-access]" <belajar-access@yahoogroups.com>
Date: Mar 16, 2015 1:15 AM
Subject: Re: [belajar-access] dua tabel ,jadi satu di query
To: <belajar-access@yahoogroups.com>
Cc:
yang anda butuhkan bukan join, tetapi cukup lookup saja.
paling mudah dengan dlookup
select * , dlookup("Standard Methods","Tabel2","hole_id='" & table1.hole_id & "' AND [Parameter of Analysis] = 'TM_ar'" as TM_arStandardMethods, dlookup("Standard Methods","Tabel2","hole_id='" & table1.hole_id & "' AND [Parameter of Analysis] = 'IM_adb'" asIM_adbStandardMethods from table1 regards,
a.k.
On 3/15/2015 8:44 PM, Ira Idotel iraidotel@yahoo.com [belajar-access] wrote:
Dear All, suhu Access sekalian
mohon saran nya , saya pakai access 2003 , ada 2 tabel beda format
untuk bikin realatioship mungkin bagi saya tidak bisa ,karena 1 tabel memanjang kesamping , dan 1 tabel kebawah .saya ingin kedua nya tergabung seperti contoh exels terlampir
kiranya ada saran / pencerahan dari member sekalian
Sebelumnya saya ucapkan terimakasih .
Salam,
Ira Borneo
__._,_.___
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
SPAM IS PROHIBITED
.
__,_._,___
No comments:
Post a Comment