For 3 or more alternatives, I prefer to use the Switch() function (for 2
alternatives the IIf() function). Something like:
= Switch([Field1] = "C", "Completed", [Field1] = "D", "Do Over",
[Field1] = "M", "Move")
--
HTH
Van T. Dinh
MVP (Access)
"NCCarol" wrote in message
news
I would like to use an if statement to display text, dependent on data in
field.
for example ; If [field] = "C", then display "completed", or if [field]
is = "D" then display "Do over", or if [field] = "M" then display
"Move".
I thought I could make it work with an IIF statement, but I cannot seem to
get it right.
Any help would be appreciated.