Creating a Table in Access with AutoNumber Field

[Catrina]

I want to create a table with an AutoNumber Field, but I can not find information on the syntax. Is it possible?

Thanks in advance for any help.

Catrina
Here is my statement as is:

db.Execute "CREATE TABLE RateRec ([RREmp] TEXT(6), " _
& "[RRSeq] TEXT (1), " _
& "[RateDate] TEXT (8), RateRate LONG, " _
& "RecordID )"
''RecordID is the field I need set as AutoNumber