Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009
    Posts
    15

    Unanswered: from table to string

    Hi,
    I need to extract all the data of a field in a table and make a dynamic string.
    It could be:

    1. aaa = extract field_name.value where row = 1
    string = "where field_name in (' " & aaa
    2. aaa = extract field_name.value where row = 2
    string = string & aaa
    ...

    until the last row
    then:
    string = string & aaa & "')"

    How can I do that?
    Thank you

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You can open a recordset on the table and loop through the resulting records.
    Paul

Tags for this Thread

Posting Permissions

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