If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
spreadsheet style
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? |
#2
|
|||
|
|||
spreadsheet style
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 "Jeff Klein" jklein@nospam wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|