View Single Post
  #5  
Old February 11th, 2010, 06:46 PM posted to microsoft.public.access.forms
Dirk Goldgar
external usenet poster
 
Posts: 2,529
Default IIf function Problem

"Pamela" wrote in message
...

Thanks so much for that response. I had to add a 3rd closed
parenthasis )))
to the formula, but then it worked perfectly.



Sorry about the error, though I really think you ought to use the
If/Then/Else block instead of the IIf.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)