How do you programmatically change a table attribute to have an index

[ToyFox]

I would like to create an index programmatically

I added 1 fields to a table using the following code...

CurrentDb.Execute "ALTER TABLE" [Accts] Add Column Test Text"

How can I change an existing field to have an index.

 

[SkipVought]

Hi,

What application?

If MS Access, please post in one of the MANY Access forums like forum705.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}