MS Access field type question

[TheBionicOrange]

In MSAccess, when you add a new record to a table which has a DATE field, do you add the value as a date, or do you need to convert the date value to a long first ?

I know when extracting from tables you need to convert the dates to longs to get your recordets, but is it the same rules when adding a record ?

[vbgladiator]

Just add them as dates.

[TheBionicOrange]

Thanks for the quick reply

[TheBionicOrange]

OK thats that sorted out, but I have a primary key on this table defined as an AutoNumber, so should I omit this field in my "INSERT INTO ...." SQL statement ?


I just realised .... I've stopped getting that damn annoying Sprinks pop-up !!

[vbgladiator]

Yes, AutoNumber fields are generally used as Key fields and are automatically generated upon inserting a new record.

[TheBionicOrange]

Thats what I thought.

Thanks for your help vbGladiator