On 7/20/2010 11:59 PM, Howard Rogers wrote:
> But how do I find records which are ONLY yellow and orange, and
> exclude records which have some other colour mixed in, in one simple
> query without a lot of 'not this, not that' additions, and without
> using multiple separate AND tests to nail it down?
> ...
> I suspect the answer is really simple... but I'm having writer's block
> today! All help appreciated.
Just use a regular ol' equals.