Finding records which conform to multiple criteria
If I have a database with following records:
Document ID, Value
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)