Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Oakland, CA

    Unanswered: Concatenate multiple records

    I'm trying to concatenate in one single record and field text from multiple records (one field) in a query. Normally it's not a problem to concatenate from the same record but can you do it from the same field in multiple records???
    table with two columns:
    1 A
    1 B
    1 C

    can I get one table with two columns with ONLY one record reading
    1 ABC

    There is function in Access to group and Count, Sum and others but not concatenate. Is it even possible?

  2. #2
    Join Date
    Jul 2004
    To read successive records of a recordset, pass the value of each record to a function, or step through a recordset using VBA DAO or ADO.

Posting Permissions

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