How do create multiple indexing access 2007 ?

  • Thread starter Thread starter derekchambers
  • Start date Start date
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
 
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.
 
Back
Top