How to link my dates in my Microsoft access table to the clock on my computer to produce an up to date difference in the date in my table?

How to link my dates in my Microsoft access table to the clock on my computer to produce an up to date difference in the date in my table?
the function to calculate the current date and time is "now()". to query the time you can type "<now()" or ">now()". to calaulate the difference, "now()-fieldname"

to insert the current ate and time into a record set the vb code "fieldname = now()" to the after_insert event

hope that helps