CAST and CONVERT

[mikeraut]

My query is...
SELECT tblExtensions.Extensions AS 'PIN', tblExtensions.Budget AS 'LIMIT',

tblExtensions.Extension is text
tblExtensions.Budget is number

I would like to convert the tblExtensions.Budget to a text/character filed for further manipulation.
In SQL it all works, how do I change this in MS Access?

 

[Jon K]

You can use the CStr() function.

SELECT tblExtensions.Extension AS PIN, CStr(tblExtensions.Budget) AS LIMIT
.