Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    1

    Unanswered: Combine fields -----ASAP

    I am trying to combine LASTNM and FIRSTNM from my PHONE table using Access 97, but it is unsuccfully.

    Please help! Thanks...

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    msaccess uses ampersand for concatenation

    select LASTNM & ', ' & FIRSTNM from PHONE

    (i stuck a comma-space between them for you)

    rudy
    http://rudy.ca/

Posting Permissions

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