A
aaron.usa
Hello ms.pub.access,
I've been assigned to generate a DB to help analyze certain capability
deficiencies within the US Army. I'm at a real show stopper based on
my
current knowledge level.
I'm in need of some kind of routine that will check the value of the
'Tier3'
field against a list of high priority tier3 values located in a
separate
table called 'mpmi'.
If a high priority tier3 value is found within my table 'analyze' from
field
'tier3' then I need the routine to generate a score of 1 and place it
into
the field called 'score'. If it does not exist then a score of 0
would be
populated instead.
I hope this question makes sense, and it seems rather complex to me so
any
assistance toward even the right angle of attack would be highly
appreciated!
All the best,
Aaron
I've been assigned to generate a DB to help analyze certain capability
deficiencies within the US Army. I'm at a real show stopper based on
my
current knowledge level.
I'm in need of some kind of routine that will check the value of the
'Tier3'
field against a list of high priority tier3 values located in a
separate
table called 'mpmi'.
If a high priority tier3 value is found within my table 'analyze' from
field
'tier3' then I need the routine to generate a score of 1 and place it
into
the field called 'score'. If it does not exist then a score of 0
would be
populated instead.
I hope this question makes sense, and it seems rather complex to me so
any
assistance toward even the right angle of attack would be highly
appreciated!
All the best,
Aaron