Define ranges within a numeric field

[hansdevr]

Hi everyone,

IMHO there has GOT to be a more clever way of doing this in stead of a nested 'if':

Anyone here found a more elegant trick to accomplish the same?

[hansdevr]

Thnx Marco! Your solution looks a lot like Massimo's, BTW.

Still, suppose I have a table with some 500,000 records and I try an interval match to the ranges table - would the nested if be more slow than the match table? I will do the experiment today..