troubleshooting Question

query help

Avatar of johnnyg123
johnnyg123Flag for United States of America asked on
Microsoft Access
7 Comments1 Solution251 ViewsLast Modified:
I have the following access table

Shop   Month    Sales
1000    1           1000
1000    2           2000
2000    1           4000
2000    2           5000

Basically there is a list of shops with sales for different months

I am trying to write a query that will list the shops and the sales
for each month across a single line
(all shops will have the same number of sales month entries)

For the sample data above I was hoping for the following

shop month1  month2
1000  1000     2000
2000  4000     5000
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros