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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nz or Iif 8
insert into 3
Iif/IsNull Question 6
Testing for null 4
Access Building a IIF expression in Access 0
update two fields at once 1
Question on Iff Statement 1
Windows 10 Error: 'CreateProcessWithTokenW' was not declared in this scope 2

Back
Top