Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    259

    Unanswered: Code to update values from table

    hi
    I have two tables; one called Data Info, and another called FileTable
    Data Info has two fields, one of which is empty. The non empty field contains ID No.s of two different kinds; one kind is a straight up number, like 233, while the other has the type FFF234, where FFF can mean any type of 3 letter combo.

    I want to update the first empty field with values from another table, FileTable whenever i come across an ID no. of type FFF***; the code will automatically look up the corresponding value for *** in the File table and then refresh the empty field with that no.

    I know only ADO, so could the code be written in ADO instead of DAO?

    thx for the help

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Yes it can ...

    SELECT * FROM [Data Info] WHERE (Left(2ndFieldName,3)='FFF');

  3. #3
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    259
    Unfortunately, the FFF is not the same for each value; some have different values, like POO, or DCA

    i just wanna know the code to update a recordset, so if left(.....) NOT an int, then do you update the field as, rec.Update "Fiedlname" value?

Posting Permissions

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