Hi There,

I have a database with 1000's of children's games. I have teachers in other parts of the world classifying the games into categories. When they log in, a find is performed to bring up a specific 100 games for that teacher to categorise based on topic. The teacher categorising the Games to teach the animals (100 games) has a readout telling the teacher that s/he is on E.g. Game 4 out of 100 which is a calcualtion I made.

Once they are done they check the 'Done' box in the Games::Done field.

The teachers have requested that there is a readout telling them how many games they have completed and I am struggling to create a formula to acheive this.

I imagine I need the count function to find not only the Games::Done that have been checked 'Done' but only those within the Games::Topic = Animals.

I have to admit, I am bit amiss as to how to create such a formula. Would it be a summary field or a count function?

Thanks so much for all your advice,

Maria

A summary field summarizes the found set - so a summary field defined as Count of [ Done ] would count only records in the current found set whose Done field is not empty.

Thanks so much. Nothing nicer than an easy solution. Have a great day.