Duplicates permitted but only if Null

  • Thread starter Thread starter Jack Sheet
  • Start date Start date
J

Jack Sheet

Hi all, Access 97

I want to permit duplicate entries in a field but only if Null.
Simply indexing the field with duplicates not permitted does not seem quite
enough, as it treats several Null entries as duplicates.

What to do?

Thanks
 
Jack said:
Hi all, Access 97

I want to permit duplicate entries in a field but only if Null.
Simply indexing the field with duplicates not permitted does not seem
quite enough, as it treats several Null entries as duplicates.

What to do?

Thanks
Click to expand...

If you actually open the indexes dialog while in table design view you can
specify "Ignore Nulls".
 

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

Unable to append table through query. 1
Error message regarding duplicate values 1
Change Error Message 1
Duplicate Values in the index, primary key or relationship 4
Access Auto Matching Duplicates? 0
new user with primary key issues 6
Unique values in two fields in query 1
Can't assign primary key 3

Back
Top