MS Access SQL - data type mismatch

[noisepoet]

Hi. While I've been writing Oracle SQL queries for a few years now, I'm relatively new to MS Access SQL. There are surprisingly few resources available online (via Google) for MS Access SQL. Given that, I'm having difficulty figuring out how to format a field which is text as a number (or vice versa). Do I use FORMAT()? Is it like this: FORMAT(FieldName,'General Number') ?

Thank you.

 

[noisepoet]

Thanks, James. Now I know exactly where to go if I want to be chastised for asking for help.