How do create multiple indexing access 2007 ?

[derekchambers]

I am trying to index multiple fields in database eg

EstItem+LineNo

 

[TedMi]

This is known as a compound index.
Open the table in design mode. Open the index dialog.
In the "Index Name" column, enter your name for the index
In the "Field Name" column, select EstItem
In the "Sort Order" columns, select Ascending or Descending
On the next line of the index grid, leave the "Index Name" column blank
In Field Name, select LineNo, then select Asc. or Desc.

-TedMi

 

[Allen Browne]

In table design view, open the Indexes box (from the ribbon.)

Enter a name for the index and the first field.
On the next line, leave the index name blank, and enter the 2nd field.