Compare query results to table list

[harrop11]

Hi,

I have tried looking everywhere for this but I’m not even sure how to word it as I’m not getting anywhere.

What i have is a basket type page which shows items in a basket. These items are shown by filtering on an order number to show only the items on this order.
I then have another table which only has one column which is populated by items selected by the administrator.

What i want to do is check to see if any of these items in the basket match any of the items in the second table.

I know a dcount would work for one item but is there any way of doing a list against a list, or even using dcount one by one referencing each item in the list automatically.

Any help here would be fantastic.

Thanks

 

[georgedwilkinson]

What the results of this "checking" procedure be? A query? A form? A report?

You could do an inner join to get the rows that "match" though I'm not sure that that is optimal for your requirements (which I don't understand).