Query with minimum field value

[Jay]

I have an Orders table that has a Freight field, a ShipCity field, OrderId
field, and CustomerID. I want to create a query that displays Order ID and
CustomerID with the minimum freight cost for orders sent to each city.

Please, use accessquery design grid.
Or SQL explained easily since I am new to this area.

Again thank you very much

 

[Duane Hookom]

You should confine your replies to the thread you began earlier.