query expression

G

gh

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?
 
G

gh

I forgot to add that i can not use the "NZ" function as results will be going
into Front Page
 
Top