Search results

  1. A

    Select records that exclude a list of words

    The purpose of the query is to extract data from a table and copy to another (there should be a INSERT INTO above the query I posted). This is the original table (table1): ID |Description |Other field... -------------------------------------------------- 1 |the cat is on...
  2. A

    Select records that exclude a list of words

    yes I've tried to add NOT in front of Instr function and also to put =0 but the words are not filtered
  3. A

    Select records that exclude a list of words

    I have a table with a field that contains a description (something like "this is my description"); right now I'm able to select all the records that contain a word from another table SELECT * FROM table1, table2 WHERE (((InStr([Description],[table2].[word]))>0)); I can't find the way to do the...
  4. A

    Hello from Italy

    Hello everyone, I live in Italy and I work for the automation industry; I use Access as a tool in support of projects development, I'm not an expert but I like to play with it and I hope I could improve my skills being here.
Back
Top Bottom