spreadsheet style

[Jeff Klein]

I have a table showing items for sale at a STATION that list specific
LOCATIONS. I have many stations and locations. see table below
STATION LOCATION ITEM
100 1 APPLE
100 2 APPLE
200 1 LIME
200 3 ORANGE
200 2 LEMMON
300 1 APPLE
300 3 LIME


I need to show data in a table in spreadsheet form
100 200 300
1 APPLE LIME APPLE
2 APPLE LEMMON
3 LEMMON ORANGE LIME


any ideas?

 

[Larry Linson]

Read up... in Help and at http://support.microsoft.com for the Microsoft
Knowledge Base and groups.google.com for newsgroup archives... on "Cross-tab
Queries" and "Pivot Tables".

I think crosstab will do what you want; pivot table, after a learning curve,
is very flexible and useful, too. And, you can use a Pivot Table view in a
Report, by embedding a Pivot Table Form in a Subreport Control. (As an
aside, you can use a Form in a Subreport Control, but you can't use a Report
in a Subform Control.)

Larry Linson
Microsoft Access MVP