DLookUp with formatting

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

Guest

From the statement below, the first parameter of the function won't work as
I'm trying to put a space betwee lastname and firstname. However, it would
work without concatenating a space.

=DLookUp("[firstName] & " " &
[lastName]","SERVER","[serverName]=Forms![Inquire Server]!server AND
[appName]=Forms![Inquire Server]!app")

What's the work around so I can insert space between them ?

Thanks in advance.
 
Back
Top