Duplicates permitted but only if Null

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
 
R

Rick Brandt

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".
 
Top