"Stephanie" wrote in message

Same #Error

I don't understand this- I have many queries that use:
=Nz([Nickname], [FirstName]) and that expression returns
the correct response.

Just a thought: what's the name of the control bound to this
expression? It must be different from the name of any of the fields
involved.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)