Pada query dibuat insert coloum, kemudian pada field diisikan :
TglHrIni: format([Tgl],"Medium Date")
Kemudian pada Criterianya diisikan :
Format(Now(), "Medium Date")
Salam,
Roland
Powered by Telkomsel BlackBerry®
From: Sumiyanto Surabaya <sumiyanto@yahoo.com>
Sender: belajar-access@yahoogroups.com
Date: Sat, 22 Sep 2012 16:49:51 -0700 (PDT)
To: belajar-access@yahoogroups.com<belajar-access@yahoogroups.com>
ReplyTo: belajar-access@yahoogroups.com
Subject: Re: [belajar-access] Filter date pada query append
pada criteria date issued diawali-diakhiri dengan tanda pagar #9/22/2012 7:51:16 am#
Thank you | Terima Kasih | Matur Suksema
Sumiyanto
Sumiyanto
From: "mujiariyanti@yahoo.com" <mujiariyanti@yahoo.com>
To: belajar-access@yahoogroups.com
Sent: Saturday, 22 September 2012 11:16 AM
Subject: [belajar-access] Filter date pada query append
Dear. Para Suhu
Sy baru bikin aplikasi sderhana ingin menampilkan data yg diissued hari ini saja, ada kendala ketika mau filter date hari ini saja sy taruh pada criteria date() utk tgl issued,tyt ga bisa muncul sama sekali
Kemungkinan tgl issued tdk terbaca
Ex.tgl issued: 9/22/2012 7:51:16 am
Apa jamnya juga terbaca ya?
Mohon pencerahannya..
Terima kasih,
Yanti
Sent from my BlackBerry®
powered by Sinyal Kuat INDOSAT
------------------------------------
SPAM IS PROHIBITEDYahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-access/join
(Yahoo! ID required)
<*> To change settings via email:
belajar-access-digest@yahoogroups.com
belajar-access-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
belajar-access-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
__._,_.___
SPAM IS PROHIBITED
.
__,_._,___
Tidak ada komentar:
Posting Komentar