1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Hi Guest, welcome to the TES Community!

    Connect with like-minded education professionals and have your say on the issues that matter to you.

    Don't forget to look at the how to guide.

    Dismiss Notice

Access 2010 AND query help

Discussion in 'Computing and ICT' started by nemesis4u, Mar 12, 2011.

  1. <font face="Calibri">I&rsquo;m having a problem with an AND query and would be grateful for any help.</font> <font size="3">The field in the table I&rsquo;m querying is made up of data such as CS,HS,S </font><font face="Calibri"> S,CA,SW </font><font face="Calibri"> CS,S </font><font face="Calibri"> CA,HS</font> <font size="3">I need to find fields containing CA and S so the query I&rsquo;m using is *CA* AND *S*.</font><font face="Calibri">However, the query is returning all fields with either CA or S contained in them rather than those containing CA and S.</font>I've tried changing the * to % but still get the same incorrect information <font size="3">Any help will be gratefully received.</font>

Share This Page