IF Then Statement

  • Thread starter Thread starter matt
  • Start date Start date
M

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
 
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
.
Click to expand...
Click to expand...
 
Back
Top