Calculating in a report

[googalabosh]

I have a database that tracks the cars I fix. I want a report to display the average number of days it takes to complete a car.

The table has two columns which have an "In" date and "Out" date. I need to calculate the number of days it takes from when a car comes in to when it goes out. I then need to calculate the average number of days it takes to get a car out. Finally, I need this number to show on a report (only the average days number).

How can I do this?

TIA!

[ranman256]

Try to do all your calculations In the query,
DateDiff("d",[startDate],[EndDate])

[googalabosh]

Thank you. Now, how do I get the average number of days to show on a report?

[pbaldy]

Try a textbox in the report footer with

=Avg(FieldName)