taccea said:
How do I creat a compound index?
I need to have an index that included 3 fields,
one is textual and the other two are numerical.
any guidance appreciated
If you want this to be your table's primary key, it's quite simple:
just open the table in design view, control-click the three fields so
that they're all selected, then click the "key" button on the toolbar.
If you want to create a compound index that isn't the table's primary
key, open the table in design view and click the Indexes button on the
toolbar. The Indexes dialog will open. On a new row, enter the name of
your index, the first field in the index, and its sort order. On
subsequent rows, leave the Index Name column blank, but enter the field
name and sort order for the other fields. Then click on the named row
and look down at the index properties shown below the field list.
Override any of those default properties if you need to.
