Access 2007: Field check query

Joined
Jul 25, 2011
Messages
2
Reaction score
0
Does anyone know how to write a query with two tables where in one table I have a field that has words that I want to find out if they exist in the other table within the field in that table?

Example: Table 1 has the word "suture" in field Expansion and I want to mark an x in field xMark in Table 2 if the word apears any where in the Expansion field in Table 2. So if the Expansion field has a record with Vicryl Sutures in it, that record would be marked in the xMark field.

Any help would be appreciated.
Thanks, Pat
 
Joined
Jul 25, 2011
Messages
2
Reaction score
0
Got the answer: In the query by design I needed to put *+[FieldName]+* in the criteria. I was missing the plus signs. Thanks, Pat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top