wondering if there is a way to shorten up this IF statement i have going on..
If my.settings.id <> 1.001 or my.settings.id <> 2.001 or my.settings.id <> 3.001 then
do it like this
end if
what im looking for is a shorter way, i have tried
if my.settings.id <> (1.001 or 2.001 or 3.001) then
do it like this
end if
but it didn't work out for me.
thanks in advanced.