Converting Text To Numbers

[paulS30berks]

I wondered if someone could help.

I am using the Val () Function to convert a text field to number within a query which still gives me a text output.

P.S I do not have permissions to change within table as using Access as a front end to SQL via link Tables.

 

[TanisAgain]

Have you tried formatting the fields property to say, fixed? I have just tried the following SQL and it seems to work OK.

SELECT tblTextToNumber.TextToNumber, Val([texttonumber]) AS [Number]
FROM tblTextToNumber;

Just a thought.