G
Guest
Is there any way to calculate a Hash number, to uniquely represent all data
in a number of fields?
There are numerous programs that work outside Access, but I need to
calculate either in Access (or Excel). Basically I need to generate a unique
ID, based on the contents of a large number of fields, so I can compare two
sets of date and eliminate duplicate entries, so having a single field to
identify on would be very useful. If this was possible, I could also think of
different "HASH" fields each based on different groups of fields.
My aim here is to import data to a table of about 100 fields, approx 25,000
records, and without normalising the data, I need to rapidly find any changed
items from the previous data. So, finding those that have not changed is a
good first step.
I can't normalise the data as different projects have different suppliers
and they all produce irritatingly different data. Long storey!
The fields contain a variety of text fields and number fields, in total the
combined length would I guess make up a memo field of up to 1000 characters.
So the question could be how can I calculate an accurate (say 98%) Hash field
for a Memo field of 1000 Characters?
in a number of fields?
There are numerous programs that work outside Access, but I need to
calculate either in Access (or Excel). Basically I need to generate a unique
ID, based on the contents of a large number of fields, so I can compare two
sets of date and eliminate duplicate entries, so having a single field to
identify on would be very useful. If this was possible, I could also think of
different "HASH" fields each based on different groups of fields.
My aim here is to import data to a table of about 100 fields, approx 25,000
records, and without normalising the data, I need to rapidly find any changed
items from the previous data. So, finding those that have not changed is a
good first step.
I can't normalise the data as different projects have different suppliers
and they all produce irritatingly different data. Long storey!
The fields contain a variety of text fields and number fields, in total the
combined length would I guess make up a memo field of up to 1000 characters.
So the question could be how can I calculate an accurate (say 98%) Hash field
for a Memo field of 1000 Characters?