UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Crosstab Query With Two Values, Access 2003    
 
   
foxtrojan
post Jan 8 2018, 05:50 AM
Post#1



Posts: 1,117
Joined: 8-May 06
From: Singapore


How to create a Cross Tab Query with two values ? I have the one ROW [ItemID], one COLUMN [Store] and two VALUES [GoodStock] and [BadStock].
I tried having TWO Cross Tab queries, but there is a conflict due to same Store IDs. Not workable. Please help




Go to the top of the page
 
Larry Larsen
post Jan 8 2018, 06:06 AM
Post#2


UA Editor + Utterly Certified
Posts: 24,239
Joined: 26-August 02
From: Melton Mowbray,Leicestershire (U.K)


Hi
Had this small demo knocking about for years, can only thank the creator..

Pay attention to both the query and the UDF function used in the example..

HTH's
thumbup.gif

Attached File(s)
Attached File  Demo_xMultiColumnXTab.zip ( 51.85K )Number of downloads: 79
 
Go to the top of the page
 
foxtrojan
post Jan 8 2018, 08:39 AM
Post#3



Posts: 1,117
Joined: 8-May 06
From: Singapore


Thank you so much Larry, it works perfectly.
Go to the top of the page
 
penfold098
post Jan 8 2018, 08:40 AM
Post#4



Posts: 139
Joined: 5-March 14



Try this technique from Allen Browne's advanced queries page.
Go to the top of the page
 
Larry Larsen
post Jan 8 2018, 12:24 PM
Post#5


UA Editor + Utterly Certified
Posts: 24,239
Joined: 26-August 02
From: Melton Mowbray,Leicestershire (U.K)


yw.gif
Go to the top of the page
 
foxtrojan
post Jan 11 2018, 02:20 PM
Post#6



Posts: 1,117
Joined: 8-May 06
From: Singapore


Wow, that's pretty cool. Thanks again Larry.
Go to the top of the page
 
Larry Larsen
post Jan 11 2018, 03:52 PM
Post#7


UA Editor + Utterly Certified
Posts: 24,239
Joined: 26-August 02
From: Melton Mowbray,Leicestershire (U.K)


uarulez2.gif
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    9th December 2018 - 11:07 PM