query expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field named DNA with some values and some null values, in a new
field i used this to insert a 0 in all null fields - IIf(IsNull([dna]),"0")
.. What do i add to get it to return original value if it is not null?
 
I forgot to add that i can not use the "NZ" function as results will be going
into Front Page
 
Back
Top