Re: [MS_AccessPros] Crosstab Queries

 

Hi youssef2309,

Please include the previous emails in the thread when you reply so we don't lose important information.

You didn't provide the SQL view as asked. 

How are you filtering the crosstab? Typically if you change the filter, the column headings will automatically adjust to the new dataset. We would need to know what you are doing that this is not happening.

Regards,

Duane

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of youssef2309@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, July 29, 2019 12:24 PM
To: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Subject: Re: [MS_AccessPros] Crosstab Queries

 

Series	Model ID	P/N	Qty/Car
G02	UJ35.A7	9909275	4.00
G05	CR65.A7	7140850	2.00
G05	JU45.A7	7468919	4.00
G07	CX65.A7	7256142	4.00
G01	KJ95.A7	9149652	2.00
G01	KJ55.A7	8491745	1.00
G30	JR35.A7	8491746	1.00
G12	7T25.A0	8170298	2.00
G02	UJ35.A7	9905911	2.00
G05	CR65.A7	7465017	2.00
G05	JU45.A7	7469254	6.00

a/m is a sample of my table

I use field SERIES to filter needed records

then create crosstab query as following shape

EX: If I filtered for G05 I will get the next crosstab results

P/N CR65.A7 JU45.A7

-------------------------------------------------------

7140850 2 0

7468919 0 4

7465017 2 0

7469254 0 6

so, how can these column header (CR65.A7) and (JU45.A7) changed when I select another SERIES

your quick response will be highly appreicated

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___