Create a non-unique index on a table

[Guest]

Could someone please tell me what the correct SQL syntax is to create a
NON-unique index (ascending) on a field in an existing AccessXP table?

Thanks much in advance.

 

[Marshall Barton]

Could someone please tell me what the correct SQL syntax is to create a
NON-unique index (ascending) on a field in an existing AccessXP table?

Execute an SQL DDL statement:

CREATE INDEX index ON table (field ASC)

or you could do it with an ALTER TABLE statement. See Help
- Contents - SQL Reference - Data Definition Language.