That will never happen. The values in both fields and the values I am
wanting to populate in the new E1 field will always be unique for any given
record. There will be multiple records that have a Cost Type of L or a Cost
Type of M, etc.....or.....a Pay Item of 955000 or a Pay Item of
955300......but each record will contain one or the other. In other words,
there would never be a Cost Type of L AND a Pay Item of 955000 in the same
record, etc.....

Thank you Karl!!!!



"KARL DEWEY" wrote:

Which gets pripority? If both IIFs are satisfied then which do you put in E1?

--
Build a little, test a little.


"Warren Phillips" wrote:

I am trying to accomplish the following in a Microsoft Access 2007 QUERY. I
want to evaluate a field called "Cost Type" for the following values and then
populate a new field (E1) with a value based on the Cost Type.

For example

If Cost Type = L, populate E1 with 1405
If Cost Type = M, populate E1 with 1410
If Cost Type = S, populate E1 with 1480
If Cost Type = G, populate E1 with 1495

Then.....I want to evaluate a different field (Pay Item) for the following
conditions and place a static value in the E1 field...and..these values a

If Pay Item = 955000, populate E1 with 1490
If Pay Item = 955300, populate E1 with 1491
If Pay Item = 955200, populate E1 with 1492
If Pay Item = 955100, populate E1 with 1493

Is there any way to combine these conditions (evalutating 2 fields) into 1
statement

Thank you

Warren Phillips