Hi -<br><br>A simplified version of my challenge is this...<br><br>I want to use a parameter query to select records that match two different Field2/Field 3 criteria.<br><br>Field1 Field2 Field3<br>lot # marker interpretation<br><br>1234 apple positive<br>1234 banana negative<br>1234 pear positive<br>5678 apple positive<br>5678 banana positive<br>5678 pear negative<br>2222 apple negative<br>2222 banana negative<br>2222 pear negative<br><br><br>So, I want to see which lot #'s are apple/positive AND banana/negative (this would be lot #1234 but NOT lot #5678 or 2222). I tried doing a subquery to first find apple/positive but then my final query showed me ONLY banana negative (although for the correct lot #). Also, I don't want to see any other records related to the lot # (no "pear" info).<br><br>I hope this makes sense to someone. <br><br>Thank you.