PC Review

Reply

Rate Thread

Parameter query with and multiple "NOT / OR" selection criteria

Peg Hall

Guest

Posts: n/a

1st Jun 2010

I get incorrect results when I do the following query:

Field a = "X"
Field b = Not "Y or Not "Z"
Field c = Between [Date 1] and [Date 2]

Reply With Quote

Reply

« Create a Query that Prompts for Date and Time | Queries »

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Selection criteria on parameter forms	amd via AccessMonster.com	Microsoft Access Form Coding	6	19th Mar 2008 10:09 AM
Copy Selection - Paste Selection - Delete Selection	Uninvisible	Microsoft Excel Programming	2	25th Oct 2007 01:31 PM
Copy Selection - Transpose Selection - Delete Selection	Uninvisible	Microsoft Excel Misc	2	23rd Oct 2007 04:18 PM
Parameter Query - Multiple Selection - Quick Question	=?Utf-8?B?U2Vhbg==?=	Microsoft Access Queries	1	31st Oct 2005 08:55 PM
error STOP:0x0000007B (parameter, parameter, parameter, parameter)	robert35	Microsoft Access Getting Started	1	15th Dec 2004 04:28 PM

Features

Forums Startup Database Reviews Articles FAQ / Guidelines About Us

Advertising

Newsgroups

Windows Vista Windows XP Microsoft Word Microsoft DotNet Windows 2000 AntiSpyware Microsoft Access Microsoft Excel Microsoft Outlook Hardware

All times are GMT +1. The time now is 01:37 PM.