Access 2010 AND Query Help

[Helen Wheels]

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

 

[John W. Vinson]

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/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com