?
Solved

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

Posted on 2006-06-09
2
Medium Priority
?
459 Views
Last Modified: 2008-02-01
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
0
Comment
Question by:LeeHopkins
2 Comments
 
LVL 15

Accepted Solution

by:
cquinn earned 200 total points
ID: 16871350
select CInt(as400.PONum) from as400
0
 
LVL 54

Expert Comment

by:nico5038
ID: 16871367
Try:

select Val(PONum) as numPOnum from as400;

Nic;o)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question