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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Safe Howard - 06 Nov 2007 16:02 GMT

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 ?

Reply to this Message

John Spencer - 06 Nov 2007 16:28 GMT

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"

Signature

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

>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 ?

Reply to this Message

Safe Howard - 06 Nov 2007 16:55 GMT

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

> 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 ?

Reply to this Message