Solved Data Type Mismatch

[MattBaldry]

Hello Forum and a happy new year,

I have a query I am trying to create with 2 tables. The issue I have is that one field is currently part of an SQL table and is Short Text. The data in here is a number though and I want to link it to a table Number field. Is there any way of getting the query to recognise the SQL field as a Number and not Short Text?

~Matt

 

[The_Doc_Man]

You might be able to use VAL(field) as a way to convert it to a number. There is also CLng(field). Since I'm not up on SQL server, I don't know if there is a better function choice, but those two would be my first two choices for an Access table.

 

[MattBaldry]

You might be able to use VAL(field) as a way to convert it to a number. There is also CLng(field). Since I'm not up on SQL server, I don't know if there is a better function choice, but those two would be my first two choices for an Access table.

I was just logging on to close this as solved. I tried the Val and it worked. I found it on an older thread.

~Matt