SOLVED - RE: [AccessD] IFF else problem

Glad it worked because I got the names confused and left out the space
between the male names

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:40 PM
> 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
> > ******************************************************************
> > *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
> 
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>