Minimum Price Query

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.