Query Criteria: Unique Number

[efleming]

Sorry if this is a no0b question, but how do you specify that a number must be unique (i.e., it can be any number - but cannot have duplicates)? Also, is there an easy way to compile/list the data which fails to meet your criteria?

[June7]

You can use Autonumber datatype or in table design set field to not allow duplicates.

You can do a Totals query that groups by the field in question and use Count function. Any numbers that have more than 1 count you can then search for in the original table to locate records and decide how to correct. Or you could join the Totals query to the original table (join type 'show all from original table...') and filter those records with count greater than 1 and thus select the records that have duplicate number.