Add fields and find percentage

[gurp99]

Hello,

I am trying to wrap my brain around access to help make my job a little easier. I am a Teacher Assistant at a University in Vancouver, BC. I have 4 tables (Course, Grade, Student, Assessment) and I have already applied the relationships and have enforced referential integrity.


I just created a List Query that displayed grades for 4 assignments (four fields have the assignment grades) and the query displays the TOTAL in the last column. I used this formula:



Grade Total: [Field1] + [Field2] + [Field3] + [Field4]


How would I be able to design a query that found students with greater than 50% on their first 3 assignments combined...

There are 4 assignments, students need to get at least 50% combined in the first three in order to get credited for the 4th assignment. So basically I need help with adding the 3 grades. The first 3 assignment total up to 50, and the last assignment is worth 50.


Any help would be greatly appreciated... Thanks in advance

[ajetrumpet]

well the percentage is what you need to focus on, so to get records that satisfy, do this maybe:

SELECT * 

WHERE (([field1] + [field2] + [field3]) / 3) > .50 

that is of course if the first 3 fields are listed as percentages, which I believe is stored in memory as decimals regardless of the interface display format