Software

Ask something
Question Locked

Minimum Price Query

0 helpful
3 replies

by aemerson

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have two tables one with purchase history and one with offer prices from suppliers. Both are linked by a Product ID Primary Key.

I want to identify in the offer prices from suppliers which is the minimum price offered for each Product ID.

I'm pretty new at using databases and have been trying to write a basic query in Access but can't get anywhere.

I am using Access 2003.

3 replies

by tony hopkinson

It's not basic this one

do a query for minimum price
e.g
select ProductID,Min(OfferPrice) From ProductOffers group By productID

The join that to Products and ProuctOffers by ProductID and OfferPrice to get Product and Vendor information back

If two vendors are offering at the same price both will come out.

Is one way, there are some others.

Look up how to do it from the front end you probably know more about that than me anyway.

Best way to approach this sort of thing is to do it in stages and then look at how (and if) you can themn make it more efficient.

This discussion is closed to new replies.