Running Current Date in a Table

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top