How to make a query that excludes certain data in access

's Computer Specifications

I have a database that includes addresses. If i want to post to everyone
except say those in scotland how could I exclude the scotland addresses from
the query?

's Computer Specifications

you're going to have to build a criteria for the country. When you build
your query, in the country column you will need to add a criteria such as '<>
"scotland"'

Daniel

"Luke P" wrote:

> I have a database that includes addresses. If i want to post to everyone
> except say those in scotland how could I exclude the scotland addresses from
> the query?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
need to create query that excludes data from another query	=?Utf-8?B?Um9iZXJ0YQ==?=	Microsoft Access Queries	1	5th May 2006 07:43 PM
How to generate #'s that excludes certain numbers?	=?Utf-8?B?ZG9qaXN0YXI=?=	Microsoft Excel Worksheet Functions	2	15th Nov 2005 07:52 PM
Make available offline excludes new subdirectories	JerryK	Windows XP General	0	6th Oct 2004 06:24 AM
Re: Add formula that excludes certain cells in the range	Frank Kabel	Microsoft Excel Worksheet Functions	7	5th Feb 2004 11:23 PM
query excludes other query	Wim	Microsoft Access Queries	4	8th Dec 2003 06:46 PM