Query with minimum field value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New Totals Query 2
Query leaving out some data 2
Test records from one table / query against a date range in another table 2
Combo box returns from query 1
Please Help with SQL Query 1
update query updates 0 records 1
Query to find minimum of two fields 3
SELECT parent with all child rows with Typed Datasets 3

Back
Top