Search results

Thanks a lot jal. that really helped. I have another question, in the following statement: SELECT COUNT(StudentID) as NumStudents, (SELECT Count(Passed) FROM TestResults WHERE Passed = True) as Passes, NumStudents - Passes as Failures, 100 * Passes/NumStudents as Percent_Of_Students_That_Passed...

Hello All, I have a database with thousands of student records. What I would like to do is create a report that adds the number of students that tested and compares it to the number passed and give me a percentage. When I create the report it always presents me with all the students listed...

Hi Everyone, I have a DB that I use to import two files, the DB then merges the records in the two files and generates a report with running sums and such. I use this quite often and I don't want to keep going throught the process of importing the files manually. And I tried using the...