Hi Colin,

Maybe they were just typos, but I've seen this OR clause several times
now in this thread:

>> But what I want is:
>> Where (((Table1.ForeignKey2 >= 962) or (Table1.ForiegnKey2 <= 973))

Don't you mean AND here? I.e.
(Table1.ForeignKey2 between 962 and 973)
?

Because the OR version, afaict, is the same as
(Table1.ForeignKey2 is not null)

Did you use the OR version for testing?


Greetings,
Paul Vinkenoog