"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)