<div>
<pre><code id="code-20-41020230-1">Where Trim(NumberValueField) Like &quot;#########.##&quot; or Trim(NumberValueField) Like &quot;#########&quot;</code></pre>
</div>


Where Trim(NumberValueField) Like "#########.##" or Trim(NumberValueField) Like "#########"

<div>
I don't think that is correct<br />
<br />
I need to return records if one of the follow conditions are not met (invalid values)<br />
<br />
1) the numbers to be numeric<br />
2) if they have a decimal place to only return 2 places to the right of the decimal (ex 343.423 = invalid)<br />
3) to have UP TO (can be less) places to the left of the decimal<br />
<br />
Invalid Values<br />
<br />
9999999999 (to many spaces to the left of the decimal)<br />
99.999 &nbsp;(to many spaces to the right of the decimal)<br />
XYZ (not numeric)<br />
<br />
Valid Values<br />
<br />
999<br />
99.99
</div>


I don't think that is correct

I need to return records if one of the follow conditions are not met (invalid values)

1) the numbers to be numeric
2) if they have a decimal place to only return 2 places to the right of the decimal (ex 343.423 = invalid)
3) to have UP TO (can be less) places to the left of the decimal

Invalid Values

9999999999 (to many spaces to the left of the decimal)
99.999  (to many spaces to the right of the decimal)
XYZ (not numeric)

Valid Values

999
99.99

<div>
<div class="content wysiwyg-content">
I need to return all the values &nbsp;where the NumberValueField (its a text in the table) that is not numeric and in the following format<br />
<br />
999999999.99 or 999999999<br />
<br />
so there is a limit to how many spaces to the left of the decimal (9) and IF (doesn't have to have one) it is a decimal number it should only have to spaces.
</div>
</div>


I need to return all the values  where the NumberValueField (its a text in the table) that is not numeric and in the following format

999999999.99 or 999999999

so there is a limit to how many spaces to the left of the decimal (9) and IF (doesn't have to have one) it is a decimal number it should only have to spaces.

SQL: Verify valid number (999999999.99 or 999999999

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.