Create Multiple Index

[NEWER USER]

Access 2007
I want to build a multiple index on a table in my database. Can anyone tell
me why this does not work?

Private Sub Command0_Click()

DoCmd.RunSQL "CREATE INDEX Models ON tblCatalogModels, (Year, Make, Model)"

End Sub

 

[Dirk Goldgar]

Access 2007
I want to build a multiple index on a table in my database. Can anyone
tell
me why this does not work?

Private Sub Command0_Click()

DoCmd.RunSQL "CREATE INDEX Models ON tblCatalogModels, (Year, Make,
Model)"

End Sub

You have an unwanted comma after the table name.