id numbers

[R9772]

i would like to build an id number from various fields can anyone help me with this?

 

[GlenJohnson]

Not quite sure what you mean! What are you trying to do? Glen A. Johnson
Microsoft Certified Professional
glen@nellsgiftbox.com

"A single stone can cause a building to collapse."
Francisco de Quevedo y Villegas (1580-1645); Spanish writer.

 

[R9772]

i was trying to create a unique field in a table that could be used to identify duplicates more accurately than what was previously used. i reasoned that if i added all of the fields across that each one should (unless it's a duplicate) create it's own unique identifier. having done that i am now in need of being able to insert this newly formed column along with the columns that make up the new column into one table and then be able to pull out only the duplicates. can you help me with that? i would appreciate any and all assistance. thanks.