Grouped index

[Geo55]

I've been looking for a (very) long moment but cann't find out how to
make a grouped index (index with more than 1 field) in Access 2003.

 

[JulieS]

I've been looking for a (very) long moment but cann't find out how to
make a grouped index (index with more than 1 field) in Access 2003.

Hello Georges,
Open the table in design view. Choose View | Indexes or click the
Indexes button. Enter the Index Name in the first empty row, select the
first field name and sort order. Select the second field name directly
under the first and select the sort order for the second row, leaving
the Index Name field empty for the second field. Repeat as necessary.

I hope this helps.
Julie

 

[Geo55]

Op Thu, 13 Mar 2008 09:24:49 -0400, schreef "JulieS"

Hello Georges,
Open the table in design view. Choose View | Indexes or click the
Indexes button. Enter the Index Name in the first empty row, select the
first field name and sort order. Select the second field name directly
under the first and select the sort order for the second row, leaving
the Index Name field empty for the second field. Repeat as necessary.

I hope this helps.

And indeed it helps ! Many thank's !
Your explanation is much beter than the help of MS ;-)

 

[JulieS]

Op Thu, 13 Mar 2008 09:24:49 -0400, schreef "JulieS"


And indeed it helps ! Many thank's !
Your explanation is much beter than the help of MS ;-)

Regards,
Georges

You're welcome George. Glad to help.
Julie