Avatar of johnnyg123
Flag for United States of America

asked on 

query help

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
Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon