In support of a data conversion effort, I'm trying to create a calculated field within a query to create a unique id from an access table for every record within the database. I was hoping to do this without having to create a sub-routine.
When the database was initially created, the index (SSN) that was initially established cannot be used or converted due to legal issues, but I need to establish a unique identifier to identify each record within a data conversion process. This new calculated field must be a text field and have a size of 15 bytes.
If anyone can help, please drop me a line.
When the database was initially created, the index (SSN) that was initially established cannot be used or converted due to legal issues, but I need to establish a unique identifier to identify each record within a data conversion process. This new calculated field must be a text field and have a size of 15 bytes.
If anyone can help, please drop me a line.
