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