I am trying to create a uniqueID based on 2 fields.
I am unsure as to where it is best to do this. In a table or in a query?
The field names are
[tblWOProgressDetail].[Activity]
and
[tblWOProgressDetail].[ResourceID]
The output I am after is the same function as I would do in excel by...