Create Multiple Index

  • Thread starter Thread starter NEWER USER
  • Start date Start date
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
 
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.
 
Back
Top