3 Replies Latest reply: Aug 8, 2017 8:21 AM by Sunny Talwar RSS

    Finding records which conform to multiple criteria

    Marko Rakar

      If I have a database with following records:

       

      Document ID, Value

      1,A

      1,C

      2,B

      2,C

      3,A

      3,B

      3,C

      4,A

      4,D

      4,E

       

      I have thousands of records of this type, I would like to make selection (and make table or table chart) representation of all documents which include any of the values I select. For example, I would like to make selection of documents which includes values A and values C or D?

       

      So in the case above, in my table I would get all rows from documents 1, 3 and 4.

       

      How would I approach making query or selection like this? (if possible, I am looking at this and my mind draws blank)