Re: [belajar-access] penulisan dan syntax sql

 

Wa alaykum salam wrb
strsql="Select bla bla  from datablabla " & _
    " where Active=1 and Employee.Name" & " like '%" & searchName & "%'" & _
    " AND Employee.EmpID=" & searchID & _
    " ORDER BY Employee.Name;"

Thx.
Wass,

2014-04-21 14:32 GMT+07:00 him mah <himmah.mlg@gmail.com>:

 

assalamu alaikum Wr. Wb.

dear temen temen belajar access semua

saya ada masalah dalam penulisan sql

saya punya query seperti dibawah

SELECT tblWilayah.Kode, tblWilayah.Nama FROM tblWilayah WHERE (((tblWilayah.Kode) Like "*" & [forms]![frmWilayah]![Kode] & "*"))

untuk penulisan dalam syntax sqlnya bagaimana ya

saya coba seperti querynya koq ngga mau ya, kira-kira salahnya dimana ya

SQL="SELECT tblWilayah.Kode, tblWilayah.Nama FROM tblWilayah WHERE (((tblWilayah.Kode) Like "*" & [forms]![frmWilayah]![Kode] & "*"))"

terima kasih

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (3)

SPAM IS PROHIBITED

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___