B
Brian H2
I am trying to get my Current Date column in my table to
update daily whether I input data or not into my Db. As of
now the date cell locks on the date and time where
information has been added.
for example: Column One Current Date
123456 07/17/03 3:45 PM
07/17/03 is when I put the information in my table and is
not the current date. I just need the date to
automatically update so that it says, 07/22/03....and so
on.
In my table design I have it set up with data type-
Date/Time, Input Mask on Short Date 99/99/00;0_ and my
Default Value at Now().
There has to be a way to do this, but I haven't quite been
able to find it.
Any help/input would be greatly appreciated-
Thanks
Brian
update daily whether I input data or not into my Db. As of
now the date cell locks on the date and time where
information has been added.
for example: Column One Current Date
123456 07/17/03 3:45 PM
07/17/03 is when I put the information in my table and is
not the current date. I just need the date to
automatically update so that it says, 07/22/03....and so
on.
In my table design I have it set up with data type-
Date/Time, Input Mask on Short Date 99/99/00;0_ and my
Default Value at Now().
There has to be a way to do this, but I haven't quite been
able to find it.
Any help/input would be greatly appreciated-
Thanks
Brian