normalize a fiel

[Joe C]

I have a uniquie field, and I want to normalize it or set it as unique to speed up queery that I run on it. How do I do this? I thought I just need to turn on normaliztion or uniqe attribute, but I cannot find steps anywhere.

Any help is greatly apprecialted

 

[Joe4]

If I understand what you are asking, go into the Table that holds this field, and change to Design View. Click the field name, and update the "Indexed" property on the General tab to "Yes (No Duplicates)"

 

[boblarson]

I have a uniquie field, and I want to normalize it

I think you are using the term normalize in an erroneous way here. A field, in and of itself, doesn't need to be normalized. A set of data may need to be normalized but a single column would not fall into that category.

You may want to read this:
http://support.microsoft.com/kb/283878

 

[Joe C]

It was the indexing step that I wanted to do.
Yes I was using normaliztion incorrectly, and searching on that. Many thanks to both of you.