Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2010
    Posts
    13

    Unanswered: Multiple Results In 1 Field?

    Hey guys, i'm using Access 2007 SQL and I was wondering if there's a way to retrieve multiple records in just 1 column and join them in 1 field, seperated by commas.

    Example:

    Code:
    Query1:
    
    InvoiceNumbers
    1254
    2684
    2569
    2657
    
    Query2:
    
    Customer	Address			Invoices
    Joe's Pizza	1048 Jake Street	1254,2684,2569,2657
    Any help would be greatly appreciated

    Thanks

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6

  3. #3
    Join Date
    Jan 2010
    Posts
    13
    That's awsome! that will definitely work! thank you so much.

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    No problemo, glad it helped.
    Paul

Posting Permissions

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