Is Iif the right function to use for the following scenario???

  • Thread starter Thread starter WilliamFence
  • Start date Start date
W

WilliamFence

I am using Access 2003. I have a form that lists states in a drop box.
Depending on what state the user chooses, I need to be able to assign an
integer to another column for use in a formula.

example:
User selects Wyoming from the drop box. The value 2 is posted in a seperate
column in the same table.
 
I am using Access 2003.  I have a form that lists states in a drop box. 
Depending on what state the user chooses, I need to be able to assign an
integer to another column for use in a formula.

example:
User selects Wyoming from the drop box.  The value 2 is posted in a seperate
column in the same table.
Click to expand...



I'm not sure you "need to be able to assign an integer to another
column for use in a formula."

Why not have a table called StateRatings with columns

StatePostalCode text(2)
StateName text(32)
RatingValue integer

A combobox control on you data entry form can use this table as a Row
Source. When you wish to perform the calculation, join to
StateRatings on StatePostalCode. The RatingValue will be there.

When modeling data, one does not duplicate values that can be derived
from other tables.
 
Back
Top