Noob missing basic concept

[Briardlady]

Total Newbie!!! First post, up all hours going in circles. I have to put out a book summarizing results from a specialised dog show. I am trying to create fields that would report one result for a specified group. Not sure if I should post this in calculations or scripts, don't have a clue if I am even on the right track. I have 2 related tables, the only relationship I have set is Entry#.

1) Entry info - w/fields like name, color, sex, etc

2) Evaluation results - w/fields like height, muzzle length, coat quality, etc.

I am trying to put together a statistics page, summarizing field results form the 106 entered dogs. For example, I want to determine the average height for all males excluding puppies, and put that number into a field on a layout page displaying similar numbers for all categories. The result should be single #s for height, length, etc.

I tried Script for the first time:

1)Find "Dog" in field ::Sex

2)Omit "Puppy" in field ::Type

3)Calculate: Sum (evaluation::Height cm ) / Count (entry info::sex )

4)Insert into field "male average height"

5)Run the script

Lots of problems.

1)I'm getting to the calculation field through the script window, and it says the result must be text - obviously, I need a number.

2)I've tried a dozen variations on just using a calculation, and they all end up reporting a result for every entry - not just one result.

A second type of result I need for the page involves ratings. For example, "coat quality" has 4 values, EX, VG, G, F. I need to pull out and count the number of males with EX, the number with G, etc. And then do all of this for females, too. And there are 43 fields I need to do that for, in each sex.

I'm missing something very basic here, I think. I started with Average, then realized I needed more than one field for that function. I'm so tired of wrestling with this, but I have to get it done in the next couple of days, and staying up all night reading "help" and every forum I can find hasn't helped. I can do the repetetive work of setting up fields, I'm good with my print layouts, I've done all the individual dog pages. But this statistics page is killing me.

Please, any help?

[bruceR]

This will be a lot easier if you can post your file for us to look at.