Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    6

    Unanswered: Copy a field from one table to another

    This is probably really basis but I am trying to copy a field that is in one table to another table and just have it become a field in all of the records in the new table. I have tried the update query, but when I do the query it says "you are about to copy 0 rows" and there are 400 entries in the field

    Help please urgently.

  2. #2
    Join Date
    Feb 2004
    Posts
    37
    Are you trying to copy the field (ie, create a new field in the new table, which is the same as the old field) or just the contents of the field?

    Brian.

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Try this
    make two RecordSet rs1 and rs2

    Do While not rs1.EOF
        rs1.Edit
        rs1(yourField) = rs2(yourField)
        rs1.Update
        rs1.MoveNext
    Loop

Posting Permissions

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