Creating Unique Numbers based off of another field of info

[jasonyard]

I am trying to figure out a way to look at a certain field (address) and based on the unique value of that field, create a unique number in another field (address_hh). Any help would be appreciated.



Thanks

[June7]

Could just concatenate address with autonumber type field. Otherwise, requires code. Generation of custom unique identifier is a common topic. Here is one thread for starters: https://www.accessforums.net/access/...nce-40410.html

[John_G]

Hi -

The technique you are looking at is called hash-coding. I know very little about it, so you will have to look it up.

Why would you want to do this? Addresses are not guaranteed to be unique, in many applications.

HTH

John

[jasonyard]

Hi -

The technique you are looking at is called hash-coding. I know very little about it, so you will have to look it up.

Why would you want to do this? Addresses are not guaranteed to be unique, in many applications.

HTH

John

In my company we give a unique number (address household) to everyone's address. So if there are 3 people with your address, they be 1000 and the 2 people with my address will be 1001 and so on. I will look in to hash coding.

Thanks.