how: set one column to be "Today"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

IN MS Access, how do i set a column, so when i open the table, it always show
the date "today".

Eg.: When i open the table, the column always shows "10/Sep/2007" as the
date today ?

Thank you very much ^_^!
 
In tabledesign goto the appropriate field and in the fieldproperties set the
defaultvalue of the appropriate field to Date(). This will display todays
date as a default value.

hth
 
Beware it will only have today's date for records created today. If you open
the table tomorrow it will still have today's date there and not tomorrow's
date.

In a query or unbound textbox of your form or report use like this --
Query -
Today is : Date()
Form or report
= Date()
 
Back
Top