oscar23445 Posted March 4, 2010 Posted March 4, 2010 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
comment Posted March 5, 2010 Posted March 5, 2010 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
comment Posted March 5, 2010 Posted March 5, 2010 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.
Recommended Posts
This topic is 5378 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now