[AccessD] sql string problem

DispName: IIf ( [tblMasterAddresses]![FirstName2] = "",
[tblMasterAddresses]![LastName]  &"  " &
[tblMasterAddresses]![FirstName1] , [tblMasterAddresses]![LastName] & ",
" &[tblMasterAddresses]![FirstName1] & " and " & [tblMasterAddresses]!
[FirstName2]  )

hth

Mark


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
Sent: 25 June 2004 02:06
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] sql string problem


I am trying to create a column for a combo box.

tblMasterAddresses

Fields

LastName

FirstName1

FirstName2

Pseudocode: If firstname2 ="",lastname,firstname1,lastname,firstname1
and firstname2

DispName:  IIf ( [tblMasterAddresses]![FirstName2] = "",
[tblMasterAddresses]![LastName] &" [tblMasterAddresses]![FirstName1] ,
[tblMasterAddresses]![LastName] &",
"&[tblMasterAddresses]![FirstName1]&
"and " & [tblMasterAddresses]! [FirstName2]  )



I keep getting string error the last 30 minutes I have been working on
it.



Thanks



JOE HECHT

LOS ANGELES CA

jmhla at earthlink.net