Average

  • Thread starter Thread starter Kent
  • Start date Start date
Could you explain what you mean by COUNT Average? Do you want to calculate
the average or do you want the count the number of different averages?

You could try using the DAvg function or a subquery.
DAvg("SomeField","SomeTable","SomeLastNameField = 'spencer'")
Or
(SELECT Avg([SomeField] FROM [SomeTable] WHERE [SomeLastNameField] =
'Spencer') as the Average.

More specific advice requires more information.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Hi

Thansk for yor reply

I needed to divide the price with the average of the whole recordset of the
price.

Kent

John Spencer said:
Could you explain what you mean by COUNT Average? Do you want to calculate
the average or do you want the count the number of different averages?

You could try using the DAvg function or a subquery.
DAvg("SomeField","SomeTable","SomeLastNameField = 'spencer'")
Or
(SELECT Avg([SomeField] FROM [SomeTable] WHERE [SomeLastNameField] =
'Spencer') as the Average.

More specific advice requires more information.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
Hi
Is it possible to count Average for a whole recordset witout grouping in an
quey?
Click to expand...
Click to expand...
 
Back
Top