<div>
If IsNumber(TextField) then<br />
&nbsp; &nbsp; Value = cInt(TextField)<br />
End If<br />
<br />
Like that?<br />
<br />
AW
</div>


If IsNumber(TextField) then
    Value = cInt(TextField)
End If

Like that?

AW

<div>
maybe the function is <br />
<br />
IsNumeric(TextField) <br />
<br />
AW
</div>


maybe the function is

IsNumeric(TextField)

AW

<div>
thank you, <br />
<br />
&nbsp; Iif(IsNumeric(TextField), CInt(TextField), 0)<br />
<br />
did the trick.<br />
<br />
cheers,<br />
dave
</div>


thank you,

  Iif(IsNumeric(TextField), CInt(TextField), 0)

did the trick.

cheers,
dave

<div>
<div class="content wysiwyg-content">
I have an access linked table to a a sql table and it lists an order qty field as text, even though it is decimal in the sql table. &nbsp;I am trying to round down (or int) in access but it won't because it is a text field. &nbsp;I cannot find the right command to convert the text field in the query to number. <br />
<br />
Thanks,<br />
dave<br />

</div>
</div>


I have an access linked table to a a sql table and it lists an order qty field as text, even though it is decimal in the sql table.  I am trying to round down (or int) in access but it won't because it is a text field.  I cannot find the right command to convert the text field in the query to number. 

Thanks,
dave


convert text field to number

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.