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,089
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,169
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: 73
 

--------------------
"Time...We have exactly the same number of hours per day that were given to Helen Keller, Pasteur, Michaelangelo, Mother Teresa, Leonardo da Vinci, Thomas Jefferson, and Albert Einstein"
H. Jackson Brown
Go to the top of the page
 
foxtrojan
post Jan 8 2018, 08:39 AM
Post#3



Posts: 1,089
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: 135
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,169
Joined: 26-August 02
From: Melton Mowbray,Leicestershire (U.K)


yw.gif

--------------------
"Time...We have exactly the same number of hours per day that were given to Helen Keller, Pasteur, Michaelangelo, Mother Teresa, Leonardo da Vinci, Thomas Jefferson, and Albert Einstein"
H. Jackson Brown
Go to the top of the page
 
foxtrojan
post Jan 11 2018, 02:20 PM
Post#6



Posts: 1,089
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,169
Joined: 26-August 02
From: Melton Mowbray,Leicestershire (U.K)


uarulez2.gif

--------------------
"Time...We have exactly the same number of hours per day that were given to Helen Keller, Pasteur, Michaelangelo, Mother Teresa, Leonardo da Vinci, Thomas Jefferson, and Albert Einstein"
H. Jackson Brown
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    23rd May 2018 - 06:09 AM