Expression for No Duplicates in a Field?

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

Hi, can anyone tell me if there is an expression to
exclude duplicates in a query field?
 
No.

If the field is from a table, you can open the table in design view, select
the field, and in the lower pane set its Indexed property to:
Yes. No Duplicates.

If it is a calculated field, you can use the BeforeUpdate event of your form
(not control) to test for duplicates. The form can be in Datasheet view if
you want it to look like a query.
 

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

Duplicate Invoice Query 1
Compare Another Field of Duplicate Records 5
Filtering "No Duplicates" 1
Duplicates 4
Excluding Records when field has multiple values 2
Eliminate duplicates from expression 2
remove duplicate records in Access 2007 7
Data mismatch error 2

Back
Top