/* */

Monday, August 22, 2011

Re[2]: [belajar-access] Query dirubah ke SQL view ....

 

jadi kayak gini ya :

strSql = "SELECT Tabel_Hari.Tanggal, Tabel_Hari.Hari, Tabel_Process.NoPesanan,
Tabel_Process.Nama_Pesanan, Tabel_Process.Jml, Tabel_Process.KodeProses,
Tabel_Process.Rencana, Tabel_Process.Aktual
FROM Tabel_Hari INNER JOIN Tabel_Process ON Tabel_Hari.Tanggal =
Tabel_Process.Tanggal;"
me.recordsource = strSql

Terus untuk meng exekusi nya gimana apa " docmd.runsql "
dan querynya sudah gak perlu lagi ya ?
maaf harap maklum

pa> bs begini bang access (banyak jg ya saudara sy... ada access tea juga :p)
pa> dim strSql as string
pa> strSql = "Syntax yg td"
pa> me.recordsource = strSql

pa> intinya begitu bro..

--
Best regards,
access mailto:access_tea@yahoo.co.id

__._,_.___
Recent Activity:
SPAM IS PROHIBITED
MARKETPLACE
A bad score is 598. A good idea is checking yours, at freecreditscore.com.
.

__,_._,___

No comments:

Post a Comment