Combining Fieilds Of A Record

[Kevin]

I need to know how to combine multiple fields of a record in order to create
a unique and logical ID so that I can avoid duplications when importing
reports.

 

[Steve Schapel]

Kevin

Go to the design view of your table, and select Indexes from the View
menu. In the indexes window, type a name for the index you want to
create, set the Unique property (in the lower section) to Yes, and in
the Field Name column, enter the names of all the fields whose combined
values would uniquely identify each record in the table.