compound index

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

taccea

While in table design view, hold down the CTRL key and click the fields.
Then click the "key" icon in your menu bar. You can use the view menu to
view "indexes" if you wish to see the compound key and change any of the
properties.

Rick B


"taccea" wrote in message
...
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

taccea

If you want to make a compound Primary Key (and I suspect that IS what you
were asking), the way Rick described is what you need to do.

However, if you already have a PK and you want a *separate* compound index,
you have to do something different.

Open the table in Design View. Click the Indexes button (it has a lightning
bolt on it). Go to the bottom of the list to a blank line and type a name
in the IndexName column. Then select a field to index. Now, on the next
line, choose another field WITHOUT giving it an index name. Do the same for
the last field. This will create a compound index.

If you select the first line in the index, you can set properties for the
index like: Unique or Ignore Nulls. If you click any other line in the
index, these options won't be available.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org



"taccea" wrote in message
...
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

taccea

Gracias !!

taccea
"Rick B" wrote in message
...
While in table design view, hold down the CTRL key and click the fields.
Then click the "key" icon in your menu bar. You can use the view menu to
view "indexes" if you wish to see the compound key and change any of the
properties.

Rick B


"taccea" wrote in message
...
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

taccea

Gracias !!!

Taccea
"Roger Carlson" wrote in message
...
If you want to make a compound Primary Key (and I suspect that IS what you
were asking), the way Rick described is what you need to do.

However, if you already have a PK and you want a *separate* compound
index,
you have to do something different.

Open the table in Design View. Click the Indexes button (it has a
lightning
bolt on it). Go to the bottom of the list to a blank line and type a name
in the IndexName column. Then select a field to index. Now, on the next
line, choose another field WITHOUT giving it an index name. Do the same
for
the last field. This will create a compound index.

If you select the first line in the index, you can set properties for the
index like: Unique or Ignore Nulls. If you click any other line in the
index, these options won't be available.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org



"taccea" wrote in message
...
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

taccea