Silver^Rose 0 Report post Posted October 16, 2008 assalamualaikum..sy nk tanya ni..mcm mana nk setkan parameter query?contoh kalo nk export out report kita leh pilih by yearthen file akan diexport ke dalam excel..da sesapa leh tlg x?? Quote Share this post Link to post Share on other sites
mus3na 5 Report post Posted October 16, 2008 ("SELECT * FROM tablename WHERE date = "' & setdate & '", databaseconnection) Quote Share this post Link to post Share on other sites
Silver^Rose 0 Report post Posted October 18, 2008 assalamualaikum..sy nk tanya ni..mcm mana nk setkan parameter query?contoh kalo nk export out report kita leh pilih by yearthen file akan diexport ke dalam excel..da sesapa leh tlg x??Thanks 4 ur respond tp x jadi pun..huhuhusyntax error jer Quote Share this post Link to post Share on other sites
coisox 0 Report post Posted October 20, 2008 (edited) cara paling senang is, kau pakai wizard MS Access tu. Dia akan tanya kau apa yg kau nak. Kau main next-next sampai puas hati then tengok result. Kalau result dia betul seperti yg kau nak, kau right click, pilih "SQL", then copy laa SQL query tu ke dalam programming kau.Utk filter by date sepertu tahun, dia tambah symbol % (nie kalau utk variable. Kalau direct input, guna ' jek) Edited October 20, 2008 by Coisox Quote Share this post Link to post Share on other sites
azdin 0 Report post Posted November 7, 2008 Terus gunakan Visual Query Ms Access tu, lagi senang -> Drag and Drob. Kemudian export kedalam Excel Quote Share this post Link to post Share on other sites