asked on

true/false statements

I have a student who did some testing example
10/30/2008 - did not pass any test so the result is FALSE
12/11/08 - passed one test so the result is TRUE
I only want this person to be counted once for TRUE and not for the FALSE. Is there a statement out there that when building a crystal report will do this. There will be two reports. One will be a TRUE report and the other will be a FALSE report.
Not sure if this make sense

ASKER CERTIFIED SOLUTION

GSQL

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

James0628

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TCHGirl

ASKER

yes, each test is a separate record. These are state tests that we give to our students every quarter. The score very for an increasement depending on the test they take. My SQL table is a bit field called NRS, so that on my web design it is a check box. When entering the test scores, I am able to see if the student increased a literacy level and if they did I check the box. When the box is checked it is a true answer otherwise it is false. As I previously stated once they are counted as a true, I don't want then counted as a false also.

SOLUTION

James0628

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

GSQL

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial