I have three table one is student, the second is Student register, and the third is course schedule

The field that I am trying to count is in students copy called (PAID) located towards the bottom it is a radio button. The radio button say yes paid or not paid.

The field that I need the count to be in is in the course schedule (TO) where it say registered paid this is a number field

I am trying to count how many student paid for that class so i know the count with out manually looking at each individual student. I would like the count to be in the course schedule SO WHEN I look at the class that are coming up i know how many student paid.

You can either email me at [email protected] .

CPR SAVES LIVES

Thanks

Oscar

This can be done by making RegisteredPaid a Calculation field =

ValueCount ( FilterValues ( List ( Students::Paid ) ; "Yes" ) )

However, I am puzzled by something: a student can register for a number of courses - but they either paid for ALL their courses, or did not pay at all?

See also:

http://fmforums.com/forum/showtopic.php?tid/181943/post/228583/#228583

Only now I see that this is a duplicate thread:

http://fmforums.com/forum/showtopic.php?tid/213604/

Please keep your issue to one thread only.

Duplicate post removed.