Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004

    Unanswered: Combining 2 key fields into an attribute

    How do i combine two different key fields into one column?
    e.g. Combine Table2.First_name and Table2.Last_name into Table1.Fullname
    Need help. Urgent.

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    1. You should be using an integer or other single unique key to define your relationships. I garauntee you will experience consitancy and normalization issues if you use your current scheme.

    2. If you still want to do this, simply use the "+" operator:
    First_name + " " + Last_name
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Aug 2004
    okie thanx... i will seek u for further enquiry

Posting Permissions

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