Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012
    Posts
    2

    Unanswered: Combining fields into 1 field - Have searched on Google

    Streets Table:
    ID Street
    1 Alpha
    2 Beta
    3 Gamma
    4 Delta

    Addresses Table:
    ID Number Street2
    1 1122 Alpha
    2 1234 Beta
    3 1245 Beta
    4 7854 Delta
    5 5980 Alpha
    6 5765 Gamma
    ...1000

    I want to combine the addresses into one field, but everytime I run a query that comes up in Google Searches, I end up with:

    New Addresses Table:
    ID Number Street2 Combined
    1 1122 Alpha 1122 1
    2 1234 Beta 1234 2
    3 1245 Beta 1245 2
    4 7854 Delta 7854 4
    5 5980 Alpha 5980 1
    6 5765 Gamma 5765 3
    ...1000

    Obviously my reference is picking up the ID from the Streets Table, how to I select the value of the Addresses Table?

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    The fact that 50 members have read your post and no one has responded is probably due to the fact that, like myself, no one has any idea what you're trying to do! I think you need to explain your statement
    Quote Originally Posted by sydcomebak View Post

    ...I want to combine the addresses into one field...
    in greater, plain-English, detail, in order for us to help you.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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