two recordsets

Results 1 to 2 of 2

Thread: two recordsets

  1. #1
    Join Date
    Dec 1969

    Default two recordsets

    I have two recordsets. One of them has an order number and a source code as it&#039;s column. The other has a matching order number, but the source code is empty. I want to put the source code value of recordset 1 into the corresponding empty column in recordset 2.<BR><BR>Any suggestions?

  2. #2
    Join Date
    Dec 1969

    Default Try This...

    Do While Not Rs1.EOF<BR> Do While Not Rs2.EOF<BR> If rs1("OrderNumber") = rs2("OrderNumber") Then<BR><BR> rs1("SourceCode") = rs2("SourceCode")<BR><BR> End If<BR> rs2.MoveNext<BR> Loop<BR> rs1.MoveNext<BR>Loop<BR><BR>KLC

Posting Permissions

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