Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 473
  • Last Modified:

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
0
Murray Brown
Asked:
Murray Brown
1 Solution
 
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

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now