Create Multiple Index

N

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
 
D

Dirk Goldgar

NEWER USER said:
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
Click to expand...


You have an unwanted comma after the table name.
 
Top