Count records on subform

[Tanya]

Thank you John
You really are wonderful.
The queries you gave me earlier will benefit me immensely over the comming days when I set up reports, and you've just given me the exact answer I had been looking for.
Thanks again.
regards
Tanya

 

[John Big Booty]

Glad to have helped. Sorry about the confusion.

 

[Tanya]

John..
I am trying to understand how the text box SumOfCountOfGood works. Is this text box searching the whole subform? I tried recreating this for SumOfCountOfAve and it wouldn't work? I cannot see how it relates to the field work or to any of the queries.
cheers
Tanya

Edit: OOps Silly me, I just realised you edited the Qry underlying the form. Thanks again

 

[John Big Booty]

Tanya, I used the expression builder to define the Control Source for Text36.

 

[Tanya]

Yes I finally worked that one out. Thanks again and I'm not worried about the earlier confusion only the amount of time you have put into this problem for me. This has been a great learning experience for me.
cheers
Tanya