Calculation Problem

[deanathpc]

O.K. I have this database that has evolved two fold since the brain storm step.

I have a Class Registration table and a Student Contact table and then another table is related to the Student Contact table to keep track of every class said student takes/attends.

In the table it has a "Overall Grade" field that contains Complete or Incomplete and possibly nothing if the record hasn't been adjusted yet.

So in the Class Registration section I want to count how many students have a status of Complete. I've tried the case and the first non-complete it find it stops. I'm not sure how to do the if / then statements if that is in fact the best way to go.

Did I make this clear enough to understand?

[mr_vodka]

Class Registration = Class Detail?

It seems like you have it but just for clarification, you should have the following: Students, Class, Registration (join) tables.

If you want to see how many students have a complete status for a particular class, you can either create a summary report that will do it or create a calc with a string of "Complete" with an additional relationship to the overall grade field.

[deanathpc]

Actually I finally got it.. It's not automatic though. I have to click a button to get these calculations done but it does work. And I was missing some relationships etc. Been playing with variables in my scripts and am finally getting some of the project list checked off!

Thanks again for your reply! :