asked on

Help me with the query

let say, i have a table tblMain
THe table has following fields:
Rec# num
Name text
Account text
Zip text
the query retrieves all from the table:
select Rec# ,Name,Account,Zip from tblMain
At some point i link the table to another table tblAccount
tblAccount has many fields, and one of them is AccountNum which has a datatype number
how to convert the datatype so called "on fly" to number

------------>select Rec# ,Name,convertonumber(Account,) Zip from tblMain
something like this

SOLUTION

Sharath S

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Roman F

ASKER

something like this, just to make sure is for ms access?

Roman F

ASKER

The CAST and CONVERT column functions do not seem to work in MS Access. How can I convert a text column to an integer (number) column?

ASKER CERTIFIED SOLUTION

Paul Jackson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Sharath S

try CINT.

select Rec# ,Name,CINT(Account), Zip from tblMain

Roman F

ASKER

TO jacko72: WORKS GREAT

I USED the val () in where part of the query and everything works!!!

THANK YOU EVERYBODY
Could you also look at my another querstion?

ID:27026674
help me with ms box in ms access 2010
05/09/11 08:50 AM, ID: 27026674 | Points: 500
help me with ms box in ms access 2010