Boolaean y or no if cell is text or number

[PG2015]

Hi,

I am looking to add a column in a query that will give a Y or No to previous column data if it contains TEXT or NUMBER (It could read "TEXT" or "NUMBER" or even Y for text or N for number).

Hope I have explained that properly.

Thanks

 

[namliam]

Try the isnumeric function

http://www.techonthenet.com/access/functions/advanced/isnumeric.php

 

[CJ_London]

in your querybuilder try

istext:iif(isnumeric([previouscolumn]),"TEXT","NUMBER")

note this does not consider nulls - which are neither text or number

 

[PG2015]

Brillian - thanks so much