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 professionals and have your say on the issues that matter to you.

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

    Dismiss Notice
  3. The Teacher Q&A will be closing soon.

    If you have any information that you would like to keep or refer to in the future please can you copy and paste the information to a format suitable for you to save or take screen shots of the questions and responses you are interested in.

    Don’t forget you can still use the rest of the forums on theTes Community to post questions and get the advice, help and support you require from your peers for all your teaching needs.

    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