adding table fields together

[Paul]

Is there any way to add two table fields together to
produce a new field in a table. I am only interested in
accomplishing this in a table so that the new value is
unique and therefore can be indexed without duplicates.

 

[John Vinson]

Is there any way to add two table fields together to
produce a new field in a table. I am only interested in
accomplishing this in a table so that the new value is
unique and therefore can be indexed without duplicates.

No.

You can create a unique Index on up to TEN fields, however; it is
neither necessary nor beneficial to store the fields redundantly.