Yes, sorry. As Dirk pointed out I contracted myself in
the first post. I always want to use LastName. Hello! I
just explained it to myself. It's working now and I
really appreciate the lessons of nz, IIF, when to use 2
statements, zero-length string and null. Thanks and
sorry for the drama. Stephanie

-----Original Message-----
On Wed, 2 Mar 2005 16:38:41 -0800, "Stephanie"
wrote:

Thanks for the lesson.

The results for someone with no Nickname, FirstName =
Collette, LastName = Champion and no OldLastName is
correct: Collette Champion.

No Nickname, First Name = Donna, OldLastName = Sellers,
LastName = Black incorrectly returns: Donna Sellers.

In your original post you said:

If there is an OldLastName, I want to use it
rather than the LastName.

There is an OldLastName. It's Sellers. The query is
returning the
OldLastName because it is not null.

The query is doing *what you asked for* - is that
perhaps something
different from what you want?

John W. Vinson[MVP]
.