If then statements in queries

[Guest_imported]

In a select query, I want to generate a new field where every instance of a non-null value (from a text field) in field one is given the number 1 in the new field, and every instance of a null value in field one is given the number 0 in the new field. How and where do I construct this If, Then statement?
Thanks in advance - John

 

[tlbroadbent]

Select col1, IIf(isnull(col1),0,1) As NewCol
From table_name Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.