G
GeeseWatcher
I am trying to build a query that will return the highest value based on the
city, state, cost.
My query has over 300,000 records with Hub City, Hub State, Destination,
Rate, Fuel, Trucker, and Total Costs. For each Hub and Destination there
could be more than one cost depending on the trucker that is used. I need to
find a way to filter for one value (Hub, Destination, Cost) using the highest
cost regardless of the trucker.
I apologize if this isn't very clear, but any help would be appreciated.
city, state, cost.
My query has over 300,000 records with Hub City, Hub State, Destination,
Rate, Fuel, Trucker, and Total Costs. For each Hub and Destination there
could be more than one cost depending on the trucker that is used. I need to
find a way to filter for one value (Hub, Destination, Cost) using the highest
cost regardless of the trucker.
I apologize if this isn't very clear, but any help would be appreciated.