[AccessD] IFF else problem

Progress but still no cigar. I tried both:

Expr1: [FirstName] & IIF([Female]="Yes","(" & [Surname] & ") " & [MarrName],[Surname])
and
Name: [FirstName] & IIF([Female]="Yes","(" & [Surname] & ") " & [MarrName],[Surname])

and get #Error in the field. But at least I don't get the Undefined Function IIF

(Note that you typed IF - which gave me the Undefined Function IIF, so I *did* change that typo)
I also tried True instead of Yes with same #Error

So we are getting there - what next?

--
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:23 AM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] IFF else problem
> 
> 
> 
> Kathryn,
> How about this:
> 
> Name:  FirstName & IF([Female]="Yes", "(" & [Surname] & ") " & 
> [MarrName], [Surname])
> 
> HTH
> Jim
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of KathrynAtGwens
> Sent: Monday, August 16, 2004 1:07 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] IFF else problem
> 
> 
> in query, I have an existing 
> Expr1: [FirstName] & " " & [Surname] & " " & [MarrName]
> 
> I have a field called Female that can be True or False.
> 
> What I want is that IF [Female] is true, then I want:
> FirstName (Surname) MarrName
> Jane (Smith) Doe
> 
> otherwise (if Female is False) then I want
> FirstName Surname
> John Doe
> 
> Based on my previously giving Drew a slightly different scenario 
> of having the married name last in parens, like
> Jane Smith (Doe), he gave me this (though I've modified [Sex] 
> being F to [Female] being True)
> IFF([Female]="True",IIF(Len([MarrName])>0),"(" & [MarrName] & ")",""),"")
> 
> But no matter how I try to combine everything in the query, I 
> can't get my results correct. I've either got too many of this, 
> or not enough of that or undefined functions
> 
> I know I can leave out the length portion because that is no 
> longer needed since I want the () around the surname of females, 
> and surname is always filled in. Here is my most recent attempt 
> without regards to the males:
> 
> Expr1: IFF([Female]="True", [FirstName] & "(" & [Surname] & ")" & 
> [MarrName])
> which does not give me any invalid syntax errors, but does give 
> me Undefined Function IIF in expression. I assume that has 
> something to do with defining the "else" portion.
> 
> So, what do I need to add? 
> 
> --
> Kathryn Bassett (at work address)
> kathrynatgwens at socal.rr.com
> kathryn at bassett.net (home) 
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com