I have two tables, one with Brands, Models, and Model IDS, and a
second table with Model IDs (primary key), and various specs (Size,
Weight, etc.). Now I want to create a report where the Models/Model
IDs are listed across the top (columns), the specs are down the left-
hand side (rows), and then the spec specifics are listed underneath
the Model IDs (in the rows). How can I do this??? Right now I am
outputting the query (which ties together the two tables) to Excel,
then copying and pasting it transposed into another spreadsheet.
There must be a way to do this directly in Access.... but HOW??? I
really do not know code, so a simple answer (if there is one) would
be great.