Re: [belajar-access] Criteria di Query Crosstab

 

Dalam penulisan type data tanggal 'Date/Time' wajib hukumnya menggunakan '#' pada awal dan akhir kriteria tanggal yang diinginkan. Between #01-01-2011# And #31-12-2011# Thank you | Terima Kasih | Matur Suksema Sumiyanto --- On Tue, 1/11/11, Huda 1810 <hudadebono@gmail.com> wrote: From: Huda 1810 <hudadebono@gmail.com> Subject: [belajar-access] Criteria di Query Crosstab To: belajar-access@yahoogroups.com Received: Tuesday, 1 November, 2011, 11:56 AM   Dear, Para Master-master Acces. Saya pengin belajar tentang membuat kriteria di query jenis crosstab,tapi saya tidak mengerti gimana cara membuatnya. misal untuk menampilkan tanggal awal s/d akhir, di query yang biasa saya berhasil memasukkan dengan kriteria Between [Awal] And [Akhir].tapi, kalau di query jenis crosstab tidak bisa muncul, malah selalu muncul pesan error "The Microsoft Jet database engine does not recognize [] as a valid field name or expression". Mohon pencerahan.. bestregards huda

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 14
• New Files 1

Visit Your Group

SPAM IS PROHIBITED

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___