Hi,
I have a table that I needs to compare 2 columns to get a 3rd column value.

I tried just joining the tables using another column. However, in my query I return multiple rows because the query doesn't know which vlaue to use.

My Table looks like this...
Code:
Skill	R1	R2	Scr
Deposit	0	159	1
Deposit	160	169	1.25
Deposit	170	179	1.5
Deposit	180	189	1.75
Deposit	190	199	2
Loan	0	229	1
Loan	230	239	1.25
Loan	240	249	1.5
Loan	250	259	1.75
Loan	260	269	2
Support	0	199	1
Support	200	209	1.25
Support	210	219	1.5
Support	220	229	1.75
Support	230	239	2
Like I said, I tried to join using the "Skill" column but I get multiple records.
AHT is the number that is being used in the below expression

This is the expression I am using in my query...
Code:
Pts: IIf([AHT]>=[R1] And [AHT]<=[R2],[Scr],[Scr])
How do I compare the R1 and R2 to get Scr in an expression or using VBA??
And to return only the row that really matches?

Thanks