Results 1 to 2 of 2
  1. #1
    Keeyter is offline Novice
    Windows 7 Access 2007
    Join Date
    Apr 2010
    Posts
    8

    Logical String Concantenation

    I know how to string two values together but I am having trouble doing the following.

    I have a Form based on Customers
    Field1 is "Business Name"
    Field2 is "Customer First Name"
    Field3 is "Customer Last Name"



    I am trying to get the following.

    If customer is a business then:

    Business Name appears from my concantenation

    If Customer is a private individual then: (This I know how to do)

    Last Name, First Name appears from my concantenation.

    I am having trouble with the logical expression. If anyone can help with the expression builder to get this value I would be forever grateful.

  2. #2
    Keeyter is offline Novice
    Windows 7 Access 2007
    Join Date
    Apr 2010
    Posts
    8
    =IIf(IsNull([Business Name]),[Customer First Name] & " " & [Customer Last Name],[Business Name])

    Solved it, big pat on the back to me!!!!!!!!!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Text string formatting
    By DanW in forum Forms
    Replies: 2
    Last Post: 11-02-2009, 11:11 AM
  2. Problem with building SQL string (VBA)
    By cdpeck in forum Programming
    Replies: 1
    Last Post: 09-15-2009, 04:25 AM
  3. Aligning a string vertically
    By Divardo in forum Queries
    Replies: 3
    Last Post: 06-10-2009, 11:19 AM
  4. How to create a query for logical combo??
    By valkyry in forum Queries
    Replies: 1
    Last Post: 10-08-2007, 02:32 PM
  5. Replies: 0
    Last Post: 12-05-2005, 04:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums