can you do this?

[ae_jester]

Hi,

Can you create an autonumber field when you are creating a table like this? If so, how????

mySQLstring = "CREATE TABLE " & resTableName & " (ResNumber LONG, CustomerID LONG, ReservationDate DATETIME, FreeDay LONG, Status TEXT (50) );"
        mydb.Execute mySQLstring