Transposed Query

  • Thread starter Thread starter Max Yaffe
  • Start date Start date
M

Max Yaffe

Dear Group,

I'm having trouble getting a handle on a particular qurery. I have
two tables, tblQuote and tblQuoteDetail. The detail table keeps line
items in a quote.

So, highly simplified tblQuote is:
Quote
Date
Value

and tblQutoeDetail is:
Quote
LineNo
Part
Quantity

I want to create a view that looks like:

quote date value quant of Part='1' quant of Part ='2'
0001 1/1/06 20 1 0
0002 1/1/06 100 0 1
0003 1/2/06 140 2 1

and so forth.

Any ideas how to transpose the part quantities so they go across the
report?

Thanks for your ideas

Max
 
Back
Top