MS Access Convert Number to Text

MS Access data users will know the complex stuff we have to work with, i.e. where one system has a number field and another system the Number field is formatted as a text. Therefore I wanted a quick method to get both, this worked. I had to send this extract to another database and then use it for my queries using a Material Number formatted as a text.