[AccessD] IFF else problem

That still left a #Error but it's moot since Patti provided a solution. You probably responded to my message before noticing her solution and my reply where I added SOLVED to the beginning. Thanks for trying again anyway.

--
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 Jim Hewson
> Sent: Monday, August 16, 2004 11:43 AM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] IFF else problem
> 
> 
> 
> Kathryn,
> On another thread, there was a discussion of code review.
> I did a code review of my own suggestion and saw that I left 
> something out.
> 
> The correct suggestion:
> Name:  FirstName & " " & IIF([Female]="Yes", "(" & [Surname] & ") 
> " & [MarrName], [Surname])
> 
> The second parenthesis does have a space after it to accommodate 
> the space before the MarrName.
> 
> Jim