Automatically insert current date in Access Table

[Guest]

I'd like to insert the current time in the table whenever I create a new row.

I've set the default value to now(), however, when I open the table in
datasheet view, it automatically inserted the time when I "open" the table in
the first row. For any new records that I enter, the current time will show
on the next row instead of keeping with the row where I type in new data.

Please help. Thanks.

 

[Guest]

Hi set the field to Date ()

next - input the data through a form not directley into the table. This
will insert the current date when you create the record.

Hope this helps

 

[Guest]

Thanks!

Hi set the field to Date ()

next - input the data through a form not directley into the table. This
will insert the current date when you create the record.

Hope this helps