Jumat, 27 Januari 2012

[MS_AccessPros] Grouping "Nots" in query criteria

 

I am using Access 2007 with a Windows 7 system.

I need to exclude a group of ID numbers from a query. I attempted
various groupings and failed. This works:

<>443 And <>444 And <>445 And <>446 And <>447 And <>448 And <>449 And
<>450 And <>451 And <>452 And <>453 And <>454 And <>455 And <<>456

but there must be an elegant way to do that.

Many thanks,

Robin Chapple

__._,_.___
.

__,_._,___

Tidak ada komentar:

Posting Komentar