Orphan Table Lookup

[#1]

Hi All,

I have an Orphan table

Min	Max	1st Rate	2nd Rate
0	500	5,00%	4,00%
500,01	1000	4,75%	3,80%
1000,01	1500	4,51%	3,61%
1500,01	2000	4,29%	3,43%
2000,01	2500	4,07%	3,26%
2500,01	12000	3,87%	3,10%
12000,01	15000	3,68%	2,94%
15000,01	20000	3,49%	2,79%
20000,01	100000	3,32%	2,65%

I then have a sum of Sales calculation that i need to evaluate against this table and return 1st and 2nd rate, i havn't a clue where to start, please can anyone assist?

[Anil_Babu_Samineni]

What i am assuming is, First do Cross table for 1st rate and 2nd rate and then use name as Sales.