Sum in reports

[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

 

[Fredg]

Add an unbound control to the report.
Set it's Control source to either:

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

or..
= Date() - [DateOut]