IF Then Statement

[matt]

Is there a way to use an IF THEN statement in a field in a
query to add a default value for all the null values.
Something like IF NULL THEN Add a value of "1" for example.
any help is greatly appreciated. thanks, matt

 

[Guest]

Figured it out on my own.
IIF([prodnum]IS NULL,"X",[prodnum])

 

[Duane Hookom]

Actually the following might be simpler:
Nz([ProdNum],"X")

--
Duane Hookom
MS Access MVP

Figured it out on my own.
IIF([prodnum]IS NULL,"X",[prodnum])

-----Original Message-----
Is there a way to use an IF THEN statement in a field in a
query to add a default value for all the null values.
Something like IF NULL THEN Add a value of "1" for example.
any help is greatly appreciated. thanks, matt
.