I need to add a field that is the current date to a table, but the date needs
to be updated automatically to always equal the current date. In Excel, this
was easily done with the "TODAY" function, but this isn't working in Access.
When I use "Date()", it returns the date that the record was created, but
does not update to the current date as time passes. In other words, if it
was created on 4/22/10, when I open the table on 4/28/10, I need that field
to read 4/28/10, even though it was created on an earlier date. I hope this
makes sense. Any help is greatly appreciated! Thanks!