report with multple calculations

[krberube]

I currently have a report that I calculate 2 values on --- "CUSTTT" and "BUSTT"
these are done using a function to calculate the number of days between dates.
basically ---- CUSTTT=recdate-issuedate
BUSTT=shipdate-recdate
This works great and I don't store the results in a table ( i know your not supposed to).

These 3 dates are tied to individual records,( all records have these dates in the table)

It has been requested to run a query (Report) to give the average CUSTTT and BUSTT number. I guess I have to look at all records, do the current calculations, then calculate an average for each one.
If this makes sense is there a way to calculate this requested report?

Thanks
Kevin

 

[MarkK]

Will a query along these lines serve your purpose?

SELECT Avg([recdate]-[issuedate]) AS CustAvg, Avg([shipdate]-[recdate]) AS BustAvg FROM Table1;