Validation Rule For only one Field

  • Thread starter Thread starter Crisyina
  • Start date Start date
C

Crisyina

I have a field labeled Line ID and there are several of the same numbers in
there. What type of text or rule do i put in the validation rule box that
only allows the table to show only unique numbers and not duplicates?
 
If you are viewing records directly in the table (which you shouldn't be)
then it is going to show you *all* of the records no matter what. You
need to create a query if you want to return records that are grouped
by a particular field or fields. Tables are for data storage and
relationships.
You should not view/manipulate data directly in a table.
 
Crisyina

If that field is truly an "ID" field, you can set the property for it to
Unique, no duplicates. No need for a validation rule.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation rule, index or neither? 6
Validation of a field 3
Validation Rule in Access 2007 3
Validation Rule 2
Validation Rule 1
Validation rules - digits & letters only 1
validation rule for not allowing duplicate entries 3
Set validation rule for many fields with vba? 7

Back
Top