Multitable + Querie, Querie 1

[FreshFish]

Hello,

New to working with access but was charged with creating a database and tools to research part prices for manufacturing.

I have made 2 tables which contain our parts with names and part numbers (key field) and the price we get the parts for from Europe (in Euros). The other table has other vendors of parts in the US with our part number (key) and the price in dollars. This gets complicated as a single part may have several prices as some vendors have quantity discounts, price breaks etc...

I made a querie (though I'm sure that there is a way to make it part of the original table) that changes the Euro value from the 1st table into dollar equivilant.

I want my querie to find all instances of a particular part number and to organize them in decending value by price in US dollars.

Thanks in advance! This is getting frustrating.

 

[grtammi]

FreshFish:

Are you tuna or trout? Haha, just kidding.

Here's a SQL query statement to get you started:

SELECT [Name], [PartNumber], [Price] FROM USTable
UNION
SELECT [Name], [PartNumber], [Price]*Conversion AS Price FROM EuroTable
ORDER BY Price DESC;

and then run your query, and you should have what you're looking for.

HTH

Greg Tammi, IT Design & Consultation
Work:

http://www.atsbell.com

Home:

http://members.shaw.ca/gregandliz

 

[FreshFish]

Halibut actually.

That helped alot! Thanks!