Not In Querry

[Guest]

I have a querry that I do not want to Show ID A1 A2 A3 and so on, I tryed
Not In("A*") but this did not work is there a way to do this without having
to
Not In ("A1","A2","A3")?
Thanks Octet

 

[Guest]

You could try the following:

not like A*

hth

 

[Guest]

I also would need to Not like A* and E* but that doesnt work

 

[Douglas J. Steele]

Not Like "A*" And Not Like "E*"

 

[John Spencer]

Not Like "[AE]*"

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..