dcsimg
Results 1 to 2 of 2

Thread: Explicit fields in Iif statement

  1. #1

    Thread Starter
    New Member
    Join Date
    Aug 2019
    Posts
    1

    Explicit fields in Iif statement

    Hello:
    Need syntax help for the following...

    =IIf((Left([guests1],1)<>" "),[Symposium_member]![name] & " " & [Symposium_member]![guests1],"")

    This does not work; my problem is how to concatenate the two fields above.

    Thanks in advance...

    Bud

    Also posted in AccessForums.net by mistake...
    Last edited by Budatlitho; Aug 15th, 2019 at 09:36 AM.

  2. #2
    Frenzied Member jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    1,503

    Re: Explicit fields in Iif statement

    This looks more like Excel VBA. Please clarify where this is being used.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width