Thread: Adding up days from Date/Time entered
View Single Post
  #2  
Old March 3rd, 2010, 01:00 AM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
  
Posts: 1,017
Default Adding up days from Date/Time entered
Jeffrey,

Look at the DateDiff function in the Help file.

Steve



"Jeffrey Wilson" Jeffrey wrote in message
...
I'm new to Access and have a Table where I'd like to put in a Beginning
date
that an item was sent out on rent, and then put a date where it was
returned
from being on rent. I'd like to set up a record that sums the number of
days
that item was out, based on the previous two records.

I'm looking for this to be shown in the Form view, as a user is putting in
the dates.

Thank you