average

  • Thread starter Thread starter Avi Algazi- Atik Computers
  • Start date Start date
A

Avi Algazi- Atik Computers

i have some data that have number how can make an average from this exaple
TLV ADL BKK SPA KA 0.00 0.00 2.25 2.25 1.95 1.85 1.85 1.85 1.85 1.85 1.85
Usd 0 0 0 0 0 0 15/05/2003 31/12/2100
TLV ADL BKK SPA SQ 30.00 4.70 1.90 1.85 1.80 1.75 1.70 1.68 2.65 2.65 2.65
Sgd 0 0 0 0 0 0 01/08/2003 31/07/2004
TLV AGH AMS RUTGES CARGO TR 115.00 0.00 0.23 0.23 0.23 0.23 0.23 0.23
726 Eur Costom docs 35eur and 0.05eur
 
There are a lot of numbers but you did not say what it was you want to average.
Access has a n average function built in as part of summation query.
It is a select query that groups information and performs various functions
on the smallest group.
If you are displaying TLV, ADL, BKK, and SPA with an average of the first
column of numbers you will get the avg of the group of records the match TLV
ADL BKK SPA.
 
As Karl pointed out, that's a lot of numbers.

Are you trying to average "across"? Are you trying to average "down"?

The aggregate average function available in the Totals query only handles
the "down" situation.
 
Back
Top