I'm having a problem with an AND query and would be grateful for any
help.

The field in the table I'm querying is made up of data such as CS,HS,S
S,CA,SW
CS,S
CA,HS

I need to find fields containing CA and S so I'm using *CA* AND *S*.

However, the query is returning all fields with either CA or S
contained in them rather than fields with CA and S.

Any help will be gratefully received.

HW

On Sat, 12 Mar 2011 16:50:04 +0000, Helen Wheels <(E-Mail Removed)> wrote:

>I'm having a problem with an AND query and would be grateful for any
>help.
>
>The field in the table I'm querying is made up of data such as CS,HS,S
> S,CA,SW
>CS,S
>CA,HS
>
>I need to find fields containing CA and S so I'm using *CA* AND *S*.
>
>However, the query is returning all fields with either CA or S
>contained in them rather than fields with CA and S.
>
>Any help will be gratefully received.
>
>HW

See my reply in gettingstarted. Please don't multipost.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com