Thread: vba code needed
10-25-06, 16:48 #1Registered User
- Join Date
- Oct 2003
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!
10-25-06, 16:53 #2Grand Poobah
- Join Date
- Sep 2003
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 ...