If field is populated then value

[philliphalljr]

Hi again...I am working on a new DB and have hit another wall. I have a table that was imported from an accounting system, the table is made up of thousands of accounts, and maybe 50 columns of data. What I would like is, if a field is populated with anything (most like some text) then it would return a value of lets say the number 1. I thought putting something in criteria would work (>0,1) but it didnt and I am now at a loss. I wish it was a simple yes or no field, but thats not the case....any help is appreciated.

[ranman256]

IIF(IsNull(field),0,1)

[Micron]

then it would return a value of lets say the number 1

to where? in the table or query? I looked at what part of the forum you posted to but got no clue as it isn't in the queries portion.

[philliphalljr]

hmmm, it returned a blank query when I entered it in the criteria...

[philliphalljr]

Sorry, I dont know how to move it.

[ranman256]

the formula is in a query field.

[philliphalljr]

His solution worked. I was putting it in the wrong spot...Thank you all and sorry for the confusion.