Results 1 to 2 of 2

Thread: vba code needed

  1. #1
    Join Date
    Oct 2003
    Posts
    61

    Unanswered: vba code needed

    I have a database in which i need to perform a task of which I am not sure how to do it. I do have some knowledge of VBA but this goes beyond.

    So here is the problem. I have table with a number of records which can be matched together by a match id. the table might look like this.

    Match ID A/F indicator Trade id Test result
    111 A 10560
    111 F 10570
    111 A 10580
    113 F 10590
    113 F 10600
    113 F 10700

    Now what I need the piece of code to do is the following: IT needs to look if one match ID has different A/F indicators --> e.g. match id 111 can have either A as a/f indicator or F . If this is the case the test result should be updated with the text "asymmetrical". For Match ID 113 the A/F indicator always has the value F. If that is the case than the Test result should be updated with the text "symmetrical"

    Can anybody help me with this?
    Nobody dies a virgin because life screws us all!

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Is going to be done 1 match at a time? Does this need to be batched (like in a report?
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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