Transposed Query

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple line items in quote 2
Query to display highest totals 1
query to change the layout of a table 1
Transpose rows to columns in Access. 3
Looping through data with calculations 1
Transpose Access Table / Query 5
Query filtering by Aggregate 3
Need help counting records by date 1

Top