<div>
Try:<br />
<br />
select Val(PONum) as numPOnum from as400;<br />
<br />
Nic;o)
</div>


Try:

select Val(PONum) as numPOnum from as400;

Nic;o)

<div>
<div class="content wysiwyg-content">
I have a linked table to an as400 db the field on the as400 is a text &nbsp;field i have a query that needs to compair the value from the as400 to an INteger(number) how so i use a cast &nbsp;or convert function in my asscess 2005 query<br />
<br />
select as400.PONum from as400<br />
<br />
in sql i would just select cast(as400.ponum as int) as ponum but it does not work in acess 2005
</div>
</div>


I have a linked table to an as400 db the field on the as400 is a text  field i have a query that needs to compair the value from the as400 to an INteger(number) how so i use a cast  or convert function in my asscess 2005 query

select as400.PONum from as400

in sql i would just select cast(as400.ponum as int) as ponum but it does not work in acess 2005

using cast or convert in assces 2005 query to convert a text field to integer

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.