Boolaean y or no if cell is text or number (1 Viewer)

PG2015

Registered User.
Local time
Today, 06:32
Joined
Feb 16, 2015
Messages
21
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.:rolleyes:

Thanks
 

CJ_London

Super Moderator
Staff member
Local time
Today, 06:32
Joined
Feb 19, 2013
Messages
16,553
in your querybuilder try

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

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

Users who are viewing this thread

Top Bottom