Or since the numbers appear to be consecutive, you could use:
Not BETWEEN 443 And 456
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Lahaina, HI)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Friday, January 27, 2012 2:21 PM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] Grouping "Nots" in query criteria
Robin,You can use: Not In (443, 444, 445, 446, 447, 448, 449, 450, 451, 452,
453, 454, 455, 456)
However, my anti-hard-coding dominant gene is screaming that these values should
be differentiated in a table some place, not hard-coded in an expression. Duane
HookomMS Access MVP To: MS_Access_Professionals@yahoogroups.com
From: robinski@mymail.net.au
Date: Sat, 28 Jan 2012 11:11:59 +1100
Subject: [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
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar