How to get best three rates on 10 in a report

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

Guest

I would like to print a report that will return the best
three freight rates for each destination I have to work
with. Each destination could have up to 20 quotations. I
want the report to return the three best per destination.

BEST 2nd BEST 3rd BEST
Ex. Florida, ABC INC DEF INC XYZ INC
Denver DEF INC PNO INC XYZ INC
...
 
Could you please share your table structure(s)? How do you define and/or
store rates? How are you storing destinations?
 
Freight destination are in one table
Freight rate are in an other table with a link to
destination table.

Destination table Field
ID as primary key
City as text
state as text
Miles as integer

Rate table field
Carrier as text
Rates as integer
Destination ID as link to destination table

I hope it will supplies additional info.

Thanks

FRED
 
Back
Top