Prev: hi
Next: My Posts
From: Jerry Whittle on 10 May 2010 13:31
Looks like I need a brain reboot. One dope-slap self-applied to the head.

Thanks John!
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"John W. Vinson" wrote:

> On Fri, 7 May 2010 12:58:01 -0700, Jerry Whittle
> <JerryWhittle(a)discussions.microsoft.com> wrote:
>
> >Not "AZ" or Not "CT" or Not "NY"
>
> Sleepy, Jerry? <g>
>
> That should be "AND" rather than "OR" - "AZ" is in fact Not "NY", so this
> criterion will delete all records in the table!
>
> >This is cleaner:
> >
> >Not In ("AZ", "CT", "NY")
>
> Absolutely better.
> --
>
> John W. Vinson [MVP]
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: hi
Next: My Posts