Thanks John,
I had seen that technique and forgot! 'Old Timers' disease.
Regards,
Robin
At 28/01/2012 11:31 AM, you wrote:
>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
>
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>
Tidak ada komentar:
Posting Komentar