Eliminating Duplicates From A Query Pull

Hello,

I am building a query that pulls from one databases but I am running into duplicates.



Here is the skinny:



From the [tbl_databases], I am setting criteria that restricts a column containing “Visio”, more specifically, “Not Like “*Visio*”. I am also setting criteria that restricts a column containing “OLD” (it is a Yes/No field).

.

The problem is that there are duplicate rows that contain both “Visio” and “Old. So, simply suing my criteria restriction are pulling out the Visio and Visio/Old orders as well as Old and Old/Visio order.



Can I create a subquery that contain the combination of “Visio” and “Old” to restrict the subset from being extracted twice?



I think I have the logic but not sure not to set it up.



Thanks

Tuktuk