Query question

[jpeasemiller]

I have access 2000....Want to exclude certain cities from my CITY field and possibly some zip codes from that field.

What is the proper syntax in a Query to accomplish this? Then I want to save the results so that I can do a mail merge with Word 2000.

Could this exclusion also be accomplished with filtering or sorting?

 

[timfoster]

To exclude certain criteria you need to use a NOT clause. These aren't very efficient though. If possible try to write your criteria so as to avoid the use of NOT
(i.e. To exclude all NN postcodes you could use:
Postcode Not Like "NN*"
or
Left(Postcode, 2) < &quot;NN&quot; Or Left(Postcode, 2) > &quot;NN&quot;
)

The second option is more efficient than the first.

 

[megw]

Tim,

Is <> as inefficient as Not?

 

[timfoster]

<> is as inefficient as it is the same as Not but < and > can use the indexing (providing it is setup) as it evaluates the duality of the statement. Not (or <>) evaluate each row.

 

[losthorizon]

Interesting! (I have a boss that uses the &quot;<>&quot; symbols often in his formulas.)