Query Syntax

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
IIf([Prefix] = "Dr." Or [Prefix] = "Rev.", [Prefix] & " ", "") &
[FirstName], etc

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Lana said:
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
Click to expand...
nothing) & FirstName, etc (I have all the rest)
 
Back
Top