Thanks for the replies.

I tried the new formulas, with the empty quotes, but now I'm not getting
anything.

The PATIENTS worksheet is linked to an Access database through a query.
Could that have anything to do with it?

-Erin



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!