Access - validation values for table field

Hi

I have an Access table with a field "Urgency".
I want one of three values to be valid for this: "high","med", "low"
How do I assign this in design view of the table?
I tried putting "high,med,low" in validation rule but that didn't work
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
mbizupCommented:
For lists of discrete values like this, I often use a lookup table to drive drop-down list options on my forms, and simply disallow nulls in the table's design.
0
 
DIIRECommented:
Can you attach a sample database?  It will help us assist you faster.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.