SOLVED - RE: [AccessD] IFF else problem

Just realized the mens last names weren't showing so I had to change this:
IIF([FEMALE], [FirstName] & " (" & [SURNAME] & ") " & [MarrName],
[FirstName] & [MarrName] )

to this
IIF([FEMALE], [FirstName] & " (" & [SURNAME] & ") " & [MarrName],
[FirstName] & " " &[Surname] )

But at least I figured it out myself - yeah!
Kathryn

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of KathrynAtGwens
> Sent: Monday, August 16, 2004 11:40 AM
> To: Access Developers discussion and problem solving
> Subject: SOLVED - RE: [AccessD] IFF else problem
> 
> 
> Yeah! That one did it! and so simple too.
> 
> Many thanks!!!
> 
> --
> Kathryn Bassett (at work address)
> kathrynatgwens at socal.rr.com
> kathryn at bassett.net (home) 
> 
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of O'Connor,
> > Patricia (OTDA)
> > Sent: Monday, August 16, 2004 11:30 AM
> > To: Access Developers discussion and problem solving
> > Subject: RE: [AccessD] IFF else problem
> > 
> > 
> > Try
> > 
> > IIF([FEMALE], [FirstName] & " (" & [SURNAME] & ") " & [MarrName],
> > [FirstName] & [MarrName] )
> > 
> > 
> > Patti
> Website: http://www.databaseadvisors.com