Microsoft KB Archive/61297

{| = Excel DAM: Finding Numbers in a Text Field =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q61297 The information in this article applies to:
 * Microsoft Excel for the Macintosh, versions 2.2 and 3.0

SUMMARY
In Microsoft Excel for the Macintosh, to find a number in a text field using the Data Access Macro (DAM), computed criteria must be used. If a computed criteria is not used, the SQL query Microsoft Excel creates will not have the proper syntax.

MORE INFORMATION
If the following is true

Table Name: TEST.CUSTOMER Field Name: CUST_CODE the computed criteria should appear as follows: A1 : A2 : TEST.CUSTOMER:CUST_CODE=&quot;15&quot; Define A1:A2 as the criteria range. This will create the following line in the SQL query

WHERE TEST.CUSTOMER.CUST_CODE = &quot;15&quot;; which is the proper syntax when searching for numbers in a text field. If a computed criteria is not used, a CL1 error will be returned.

For more information on computed criteria, see pages 371-378 in the &quot;Microsoft Excel User's Guide,&quot; version 3.0 manual. If you are using Excel 2.20, see page 171 in the &quot;Microsoft Excel Reference,&quot; version 2.2 manual.
 * }