Average Number of Days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:
I have a report pulling from a query that is pulling from the following two tables:
"General Information"
"Applicant1"
In the "general information" table, there is a field called 'Date of Application' and also a field called 'Date Received in Ops'. In the "Applicant1" table there is a field called 'Applicant1 Date Letter Mailed'. I am trying to get my report to tell me the average number of days that have elapsed for all of my records in the query from 'Date of Application' to 'Applicant1 Date Letter Mailed', and also the average number of days from 'Date Received in Ops' to 'Applicant1 Date Letter Mailed'. Please help if you can. Thanks!
 
I would create 2 new fields in the query. Use the
datediff function to get the number of days between your
dates. Then, in the report, you can sum up the number of
days, count the number of records, and divide the number
of days by the count of records - should give you the
average.

-----Original Message-----
Hello:
I have a report pulling from a query that is pulling from the following two tables:
"General Information"
"Applicant1"
In the "general information" table, there is a field
Click to expand...
called 'Date of Application' and also a field called 'Date
Received in Ops'. In the "Applicant1" table there is a
field called 'Applicant1 Date Letter Mailed'. I am trying
to get my report to tell me the average number of days
that have elapsed for all of my records in the query
from 'Date of Application' to 'Applicant1 Date Letter
Mailed', and also the average number of days from 'Date
Received in Ops' to 'Applicant1 Date Letter Mailed'.
Please help if you can. Thanks!
 
Back
Top