Validation Rule For only one Field

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?
 
B

Beetle

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.
 
J

Jeff Boyce

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 2
Validation Rule in Access 2007 3
Validation Rule 1
validation rule for not allowing duplicate entries 3
validation rule 1
Validation Rule for maximum length 6
validation rule (for a record in a table) with dlookup 7
Validation rule, index or neither? 6

Top