How t prevent duplicate record set

[sriramus]

Hi All,

I have a recored set and i dont want a duplicate of the record set in the same table.

Say if my table name is businessskills and contains three fields(columns) and their names(Email , B_code, Rating) highlighted in red with data are as below

Email B_code Rating
hugh@hp.com b001 1
hugh@hp.com b002 3
hugh@hp.com b005 2
ston@hp.com b002 3
ston@hp.com b007 3

I have 5 recordsets in my table as shown above and i want to prevent any e duplicates.

Is this possible to implement to with excel vba code or directly in Access Database, either ways is fine with me.

Can any one please help me with this.

Thanks in advance

 

[MartijnR]

What do you mean by duplicates?

Entire records or same entries in a field (email perhaps?) ?