Best way to add a current run date to a make table query?

[AtLarge]

I just want to automatically add a current date and or time stamp field to table whenever it is created so I know how fresh the data is. Is there an easy way to do this?

 

[jdraw]

??? You want to put a timestamp on a record when it is created??

Add a field to your table eg CreateDate and make the default either Now or Date
Now includes Time Hr, min,sec. Date just records Day Month and Year.

 

[bob fitz]

For the created Date or Time set the fields Default Value property in the table to:
Date() to save date or Now() to save date and time. You could also do this at the form level.

 

[AtLarge]

Ah... That's it! Thank you both.