Sum in reports

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I am doing a report in Access 97, I want to know the
number of days something has been out

e.g if out since 10/09/03 and todays date is 15/09/03 then
I want to display the number of days as 5.

In the main table I have the date it went out so how do I
display the total number of days
 
Add an unbound control to the report.
Set it's Control source to either:

=DateDiff("d",[DateOut],Date())

or..
= Date() - [DateOut]
 
Back
Top