Access 97 Multiple Table Query Question

[Jeff Homan]

Hello all,

I have a problem with a query in Access 97, and I'll try to give you
all of the details to see if you have any idea if it's even possible:

I have 2 tables: Inventory and Pricing

The inventory table basically has a part number, and all of the part
details:

Part Number Part Description Weight Category
------------------------------------------------------------------------------------
000125465 Test Part 35 Muffler

I also have a pricing table that contains the part number, and
multiple pricing for that part such as:

Part Number Price Type Price
----------------------------------------------------------------
000125465 Sale 55.00
000125465 Retail 104.00
000125465 Web 49.00

What I'm trying to accomplish with a query is that I'd like all of
this data to come back in one row

Part Number - Part Description - Weight - Category - Sale Price (If it
exists) - Retail Price (if it exists) - Web Price (if it exists)

The problem that I have is that when I build a query I can only seem
to get one price and price-type from the pricing table, so when there
are 3 prices in the pricing table, I get 3 results returned in my
query.

If you have any ideas, or suggestions on where I might be able to find
a solution to this, I would really appreciate that.

Thank you,
Jeff Homan

www.jcswebhosting.com

[Allen Browne]

Answered in m.p.a.queries