rpraveen6r
New member
- Local time
- Today, 04:37
- Joined
- Sep 7, 2015
- Messages
- 1
Hi Sir...
I am new to MS Access. I am entrusted with a project in my office. The project table has three fields 'Theory Total', 'Practical Total' and 'Grand Total'. My requirement is query should look into these fields and say that if 'Theory Total' is less than 60% marks then it should say 'Failed in Theory'. Same way to 'Practical Total'. If any body score more than 80% in 'Grand Total' then it should say 'Pass' otherwise 'Fail'
___________________________________________________________
Theory Total Practical Total Grand Total Result
--------------------------------------------------------------------
45 Failed in Theory
72 67 Failed in Practic
72 85 81 Pass
I am new to MS Access. I am entrusted with a project in my office. The project table has three fields 'Theory Total', 'Practical Total' and 'Grand Total'. My requirement is query should look into these fields and say that if 'Theory Total' is less than 60% marks then it should say 'Failed in Theory'. Same way to 'Practical Total'. If any body score more than 80% in 'Grand Total' then it should say 'Pass' otherwise 'Fail'
___________________________________________________________
Theory Total Practical Total Grand Total Result
--------------------------------------------------------------------
45 Failed in Theory
72 67 Failed in Practic
72 85 81 Pass