1 Reply Latest reply on Dec 11, 2013 10:02 AM by james.diaz

    Look up 200k numbers within range in Access DB

    james.diaz

      Hello. In an Access DB, I have Field1 and Field2 defining the start and end of a number range, and I need to look up 200k numbers simultaneously, and return the corresponding Field1 and Field2 values where they are the number range the 200k numbers fall within. I am able to do one at a time with calculated field, IF ([number] > [Field1] and [number] < [Field2]) THEN  'T' ELSE 'F' END, then I use filter by T to get the right Field1 and Field2 values, but what's the best way to look up 200k at once rather than just 1?