Look at field, check to see if that value exists in another table andact accordingly.

  • Thread starter Thread starter aaron.usa
  • Start date Start date
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
 
Try this after backing up your database ---
UPDATE analyze LEFT JOIN mpmi ON analyze.Tier3 = mpmi.Tier3 SET
analyze.score = IIf([mpmi].[Tier3] Is Not Null,1,0);
 
Try this after backing up your database ---
UPDATE analyze LEFT JOIN mpmi ON analyze.Tier3 = mpmi.Tier3 SET
analyze.score = IIf([mpmi].[Tier3] Is Not Null,1,0);

--
KARL DEWEY
Build a little - Test a little

[email protected] said:
Hello ms.pub.access,
Click to expand...
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.
Click to expand...
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'.
Click to expand...
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.
Click to expand...
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!
Click to expand...
All the best,
Aaron
Click to expand...
Click to expand...

Sweet!
Thanks a million!
That worked like a charm.

Kind Regards,
Aaron
 
Back
Top