View Single Post
  #9  
Old December 29th, 2009, 05:52 PM posted to microsoft.public.access.tablesdbdesign
David W. Fenton
external usenet poster
 
Posts: 3,373
Default How do I save the date a record was last modified in Access 2003

"Al Campagna" wrote in
:

Regarding your comment about capturing Date instead of Now,
it's
usually preferable to capture Now... but just display Date format.


It is perhaps preferable to *you* -- for me, I vastly prefer a
date-only field. Where I need the time value, I use a separate
column for the time part.

If an active and busy DB, which might have multiple edits
within a
day... it's
better to capture Now. So I think it's more a case of... why
guess whether Date is sufficient... just do Now, and you're always
OK.


But it's much harder to query date fields with time parts,
particularly if you are only ever displaying the date part.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/