<div>
first, you need to create a UDF to parse the content of the field Product to get all the colors for that record.<br />
next is to compare the result to the values in the &nbsp;second table.<br />
<br />
<br />
a sample db is needed to do this.<br />
<br />
upload a copy of the db with the two tables.
</div>


first, you need to create a UDF to parse the content of the field Product to get all the colors for that record.
next is to compare the result to the values in the  second table.


a sample db is needed to do this.

upload a copy of the db with the two tables.


db12.mdb [https://filedb.experts-exchange.com/incoming/2016/11_w46/1126476/db12.mdb]

db12.mdb

<div>
the color field contains text that are not color, is this correct &nbsp;(21 - 29 in)
</div>


the color field contains text that are not color, is this correct  (21 - 29 in)

<div>
Yes, 2 records, but I need to find those as well.
</div>


Yes, 2 records, but I need to find those as well.

db12_rev.mdb

<div>
<div class="content wysiwyg-content">
I have a table named Orders with field Product. In that field, there is string of text which contains the color of the product. In another table, I have field Color, which has all the possible colors that may be in the text string in the other table. I need to count the number of Products in table Orders that have the Color from the second table. Reason: I need to count how many orders used each possible Color. Ideally, I would add a field called Color in table Orders right after field Product which would store the color found in the other table.
</div>
</div>


I have a table named Orders with field Product. In that field, there is string of text which contains the color of the product. In another table, I have field Color, which has all the possible colors that may be in the text string in the other table. I need to count the number of Products in table Orders that have the Color from the second table. Reason: I need to count how many orders used each possible Color. Ideally, I would add a field called Color in table Orders right after field Product which would store the color found in the other table.

2 Access tables, count verbiage used

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.