Need Query Help!! Tough!!!

[MikeDNova]

hey guys,

I have 4 tables t-shirt, size, color, and quote.
the size, color, and quote tables all have foreign keys in the t-shirt table.

I'm trying to do a query that will give me results formatted like this:

(size1) (size2) (size3) (size4)
Quote color quantity quantity quantity quantity

the tables are listed with more detail below.

any help would be appreciated, thanks!


t-shirt: quantity size: size color: color quote: quote
sizeID sizeID colorID quoteID
colorID
quoteID
ID

 

[JeremyNYC]

Look into crosstab queries. =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.