How do I increase query field length (>20 characters) ?

[Safe Howard]

I want to exclude 3 or 4 variables from a particular query. Using Not
"xx"or"yy" is fine, but when excluding more than this, query fails. I think
the problem is that the total text characters is quite large (approx 60
characters in total, from four exclusions). Ideas, please ?

 

[John Spencer]

60 characters is not the limit. 1024 characters is the limit.
POST the SQL of the query that is not working (View: SQL on the menu) or at
a minimum post what you are attempting as the criteria.

Also "query fails" does not tell us if you get an error (what is it) or the
wrong results (why are they wrong) or the computer crashes. Can you expand
on this?

As a guess you might want to try something like
Not In ("xx","yy","zzz","Abce")

Also you may have the boolean logic wrong and want the following critieria
(using "AND" and not "OR").
Not "xx" AND Not "yy" AND Not "ZZ"



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

 

[Safe Howard]

Thanx John - 'and not' worked ! Thanx for your help