By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,526 Members | 1,895 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,526 IT Pros & Developers. It's quick & easy.

Access 97 Multiple Table Query Question

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Answered in m.p.a.queries
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.