How to convert text string to number in Access function

[heslopwv]

Within Access 2007, I am querying on two tables where an ID number is stored as a text field in one table, and a number field in the second table. In order to connect and query on them both, I need them to be similar. In addition, converting them to number would allow the leading zeros to fall off as well. I would assume there is a function that does this, but I have not found one to work correctly. I appreciate any help anyone can give.

*I realize that I can change the tables (make table) manually, but I want to include a query in a macro to automate the step.

 

[Joe4]

Welcome to the Board!

Try using the VAL function, i.e.

ConvertedID: Val([FieldName])

 

[heslopwv]

Yeah....that was it. I had actually tried it, but was wrong in how I was doing an update qry rather than thinking I had the wrong function. Thank you for the very quick response!!!

 

[felipe77]

This information was useful for me.

Thanks.