Access 2000

Dear Experts,

Could you please check the attached small database, it contains Table1 as

Item      Sales      Qty
10101      West      1
10102      East      3
10102      North      4
10103      South      6
10103      East      7
10104      West      7

based on this a crosstab query like

Item      East      North      South      West
10101                        1
10102      3      4            
10103      7            6      
10104                        7

Could you please advise is there method in Access to not summarize the quantities, rather bringing the header category for the item? I imagined it like below

Item      East      North      South      West
10101                        West
10102      East      North            
10103      East            South      
10104                        West

thanks,
CrosstabHeaders.zip
LVL 1
csehzIT consultantAsked:
Who is Participating?
 
GRayLCommented:
This do it?

TRANSFORM First(Sales)
SELECT Item
FROM Table1
GROUP BY Item
Pivot Sales;
0
 
coolcurrent4uCommented:
Your requirements are not clear, what exactly are you trying to do?
0
 
coolcurrent4uCommented:
post a picture of what the final output should look like
0
 
csehzIT consultantAuthor Commented:
GRayL that is perfect :-) Thanks very much
Access.jpg
0
 
GRayLCommented:
Thanks, glad to help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.