Re: [belajar-access] Menambah criteria pada Query Crosstab

 

Crosstab query memang tdk bisa dipasangi parameter spt itu.

sedikitnya ada 2 cara yg bisa anda gunakan:

1. buat sebuah table utk menampung kriteria filter, (a) join kan dg crosstab atau (b) gunakan function dlookup atau (c) gunakan subquery.

2. buat query yang menggunakan crosstab tadi sbg source, lalu filter di query tsb.

good luck!

HAER

Haer Talib

RumahAccess Indonesia

Tempatnya Belajar Microsoft Access

Artikel | Forum | Milis | Download | Training | Links | Blog | Event

2017-07-12 12:54 GMT+07:00 sumbermakmur99@yahoo.co.id [belajar-access] <belajar-access@yahoogroups.com>:

Dear rekan rekan master access

Mohon bantuannya cara menambahkan Criteria pada Query Crosstab . Hasilnya error ketika saya ketik di criteria contoh: [form]![formbarang]![satuan]
Terimakasih atas bantuannya dan maklumi karena saya niwbie 😂😂

Salam


------------------------------------
Posted by: sumbermakmur99@yahoo.co.id
------------------------------------

SPAM IS PROHIBITED
------------------------------------

Yahoo 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:
    https://info.yahoo.com/legal/us/yahoo/utos/terms/

__._,_.___

---

Posted by: Haer Talib <haertalib@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

SPAM IS PROHIBITED

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___