Like wildcard w/ field from another table

[pdxmark]

Hope someone has a simple solution to this but I am trying to figure out how to setup an access project query where one field’s criteria uses the Like operator, a wildcard, and another table. The SQL WHERE statement would look something like this:

WHERE dbo.Contacts.Email LIKE *dbo.Domains.DomainName

I basically want to find all Emails within certain domains from a table.

Thanks,
Mark

 

[M8KWR]

A bit unsure what exactly it is you are trying to do, but enclose what you are trying to search for with a * each side like the statement below.

WHERE (((dbo.Contacts.Email ) Like "*dbo.Domains.DomainName*"));


hope this helps..