Hi,
I want to eliminate duplicate data entry by using DCount. I have 'Name', 'Date and 'Status' fields. The condition requires that only unique entry is allowed in Status field for a specific Date and Name.
I have used the following code, but encountered syntax error in Dcount statement...