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" <(E-Mail Removed)> wrote in message
news:88DBF188-1446-43D3-8C5F-(E-Mail Removed)...
> 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.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)