What About This Average?...Field Average...

[johann201]

Hi guys!!!!

I try to find an answer in the forum about "Average Fields",but ican't
I am confused

I wan't to export Avg Of the fields like in the panel below:

 

[KKilfoil]

What you have is a sample of a spreadsheet.

If this is your Access table structure, then you are not normalized

You should have a table structure like:
RecordID (autonumber), to uniquely identify each record. {Optional, but strongly recommended}
SampleID (integer)
CriterionID (integer)
Value (real or integer, depending on your allowable value. You will want real if you need fractional amounts)

Your data records would look like:
1,1,1,0.0
2,1,2,1.0
3,1,3,1.0
4,2,1,1.0
5,2,2,2.0
6,2,3,3.0
7,2,4,4.0
8,3,1,1.0
9,3,4,0.0
10,4,1,0.0
11,4,2,0.0
12,4,3,0.0
13,4,4,0.0
14,5,1,0.0
15,5,2,0.0
16,5,5,5.0

The RecordID values will autogenerate as you add records, and you would construct forms/subforms to make the other data easy to add.

Then create one or more summary queries to do things like count, sum, average, standard deviations, etc

Then, if you need to, make one or more reports to print the results out in a pretty format.

 

[johann201]

Thank u KKilfoil...You Have Right!!!!!!!!
I'll try to do that
I'll send u my DataBase to your mail to tell me about if u want....Thnx In advance Man...Tnx

Johann From Xanthi,Greece....