MS ACCESS MAILING LIST: Re: [belajar-access] tanya multi query by combo box

Saturday, May 7, 2011

Re: [belajar-access] tanya multi query by combo box

Menurut saya, kriterianya ditambah:

SELECT BU_AMBIL.*, BU_AMBIL.BU_A, BU_AMBIL.id_as
FROM BU_AMBIL
WHERE (((BU_AMBIL.BU_A)=IIf(IsNull([Forms]![BU_AMBILEN]![C_XX]),"*",[Forms]![BU_AMBILEN]![C_XX])) AND ((BU_AMBIL.id_as)=IIf(IsNull([Forms]![BU_AMBILEN]![id_as]),"*",[Forms]![BU_AMBILEN]![id_as])));

Semoga membantu dan memberi manfaat..

Hariyanto (Surabaya)

--- On Sat, 7/5/11, Rusmanto <rusmanto@tokatindung.com> wrote:

From: Rusmanto <rusmanto@tokatindung.com>
Subject: [belajar-access] tanya multi query by combo box
To: belajar-access@yahoogroups.com
Date: Saturday, 7 May, 2011, 3:18 PM

Assalamuallaikum,

Temen2 saya ada masalah gimana caranya membuat multi Query di Form berdasarkan pilihan di combo Box:

contoh:

SELECT DISTINCT TblProduction.dari
FROM TblProduction
WHERE (((TblProduction.dari) Like (IIf([Forms]![FormPIT]![cbxdari] Is Null,"*",[Forms]![FormPIT]![cbxdari]))))
ORDER BY TblProduction.dari;

Tapi ini hanya bisa pilih satu pilihan saja, gimana caranya kalau saya mau pilih 2 atau lebih, semacam disorot atau pilih menggunakan select+Ctrl .

kiranya ada temen2 yang bisa bantu, sebelumnya terimakasih banyak.

salam
Rusman
Manado

*** 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.&nb sp;
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.