SOLVED - RE: [AccessD] IFF else problem

KathrynAtGwens kathrynatgwens at socal.rr.com
Mon Aug 16 13:39:56 CDT 2004


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
> ******************************************************************
> *Patricia O'Connor
> *Associate Computer Programmer Analyst
> *OTDA - BDMA
> *(W) mailto:Patricia.O'Connor at dfa.state.ny.us
> *(w) mailto:aa1160 at dfa.state.ny.us
> ******************************************************************
>  
> 
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com 
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> > KathrynAtGwens
> > Sent: Monday, August 16, 2004 02: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




More information about the AccessD mailing list