Query Syntax

[Guest]

Hi

Can anyone quickly tell me the correct syntax for an added field in a query that will sa
If Prefix = Dr. or Rev. then enter Prefix & " " (space), else "" (do nothing) & FirstName, etc (I have all the rest
Thanks

Lan

 

[Douglas J. Steele]

IIf([Prefix] = "Dr." Or [Prefix] = "Rev.", [Prefix] & " ", "") &
[FirstName], etc

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi,

Can anyone quickly tell me the correct syntax for an added field in a query that will say
If Prefix = Dr. or Rev. then enter Prefix & " " (space), else "" (do

nothing) & FirstName, etc (I have all the rest)

 

[Guest]

Hi Doug

Thanks so much for the concise, really quick response. I appreciate it

Lana