• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

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
0
csehz
Asked:
csehz
  • 2
  • 2
1 Solution
 
coolcurrent4uCommented:
Your requirements are not clear, what exactly are you trying to do?
0
 
GRayLCommented:
This do it?

TRANSFORM First(Sales)
SELECT Item
FROM Table1
GROUP BY Item
Pivot Sales;
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now