MS Access field type question

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 ?

Just add them as dates.

Thanks for the quick reply :)

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 !!

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

Thats what I thought.

Thanks for your help vbGladiator :D