Averages

  • Thread starter Thread starter LG
  • Start date Start date
L

LG

I have a query built to find out how many days are between Submit_Date and
DOF. I am trying to get the average of all the days. I have tried the
Average group and also expression but keep getting an error any suggestions.
 
Edit your query this way --
Num_Of_Days: Abs([Submit_Date] - [DOF])

Remove any other fields from the row.
Click on the Totals icon that looks like the letter 'M' on its side - ∑
In the Total row select Average.
 
Maybe i was unclear. I tried your below suggestion and got the same result
as my 1st query. I need to I guess take that total number of records (count)
/ by the total Number of days?
Would you have any ideas

KARL DEWEY said:
Edit your query this way --
Num_Of_Days: Abs([Submit_Date] - [DOF])

Remove any other fields from the row.
Click on the Totals icon that looks like the letter 'M' on its side - ∑
In the Total row select Average.

LG said:
I have a query built to find out how many days are between Submit_Date and
DOF. I am trying to get the average of all the days. I have tried the
Average group and also expression but keep getting an error any suggestions.
Click to expand...
Click to expand...
 
Edit your query this way --
Num_Of_Days: Abs([Submit_Date] - [DOF])

Remove any other fields from the row.
Click on the Totals icon that looks like the letter 'M' on its side - ∑
In the Total row select Sum.

Then click on DOF and drag to the Field row.
In the Total row select Count.

Save query as Days_Submit_Date_DOF

Create another query using Days_Submit_Date_DOF for the data.

In field row enter --
My_Average: [Num_Of_Days]/CountOfDOF

Run query.

LG said:
Maybe i was unclear. I tried your below suggestion and got the same result
as my 1st query. I need to I guess take that total number of records (count)
/ by the total Number of days?
Would you have any ideas

KARL DEWEY said:
Edit your query this way --
Num_Of_Days: Abs([Submit_Date] - [DOF])

Remove any other fields from the row.
Click on the Totals icon that looks like the letter 'M' on its side - ∑
In the Total row select Average.

LG said:
I have a query built to find out how many days are between Submit_Date and
DOF. I am trying to get the average of all the days. I have tried the
Average group and also expression but keep getting an error any suggestions.
Click to expand...
Click to expand...
Click to expand...
 
That worked thanks

KARL DEWEY said:
Edit your query this way --
Num_Of_Days: Abs([Submit_Date] - [DOF])

Remove any other fields from the row.
Click on the Totals icon that looks like the letter 'M' on its side - ∑
In the Total row select Sum.

Then click on DOF and drag to the Field row.
In the Total row select Count.

Save query as Days_Submit_Date_DOF

Create another query using Days_Submit_Date_DOF for the data.

In field row enter --
My_Average: [Num_Of_Days]/CountOfDOF

Run query.

LG said:
Maybe i was unclear. I tried your below suggestion and got the same result
as my 1st query. I need to I guess take that total number of records (count)
/ by the total Number of days?
Would you have any ideas

KARL DEWEY said:
Edit your query this way --
Num_Of_Days: Abs([Submit_Date] - [DOF])

Remove any other fields from the row.
Click on the Totals icon that looks like the letter 'M' on its side - ∑
In the Total row select Average.

:

I have a query built to find out how many days are between Submit_Date and
DOF. I am trying to get the average of all the days. I have tried the
Average group and also expression but keep getting an error any suggestions.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top