Finding a Row in Table with a Range of Numbers 1

[kahunaharpervance]

I know how to do this in Excel - Having mucho troubles bending Access to my will.

Table Form:
ID MinLotSize MaxLotSize Samplesize
1 2 8 2
2 9 15 3
3 16 25 5
4 26 50 8

..and so on

An order for parts has a field called "PartsQty".
I need to return "SampleSize" from this table where "PartsQty" is = or > "MinLotSize" AND < "MaxLotSize"

Excel Function VLookup (PartsQty, Range, 2, True) would easily return the proper Value, but I don't know where to start with MSAccess.

I know I'm overlooking something very Basic, but I'm stumped!

 

[PaulBricker]

You could add another column to your query.

myFilter:IIF(PartsQty>= MinLotSize and PartsQty < MaxLotSize,"True","False")

Then on the criteria line, filter for "True"


Paul