Sql query in Ms Access

[vusolution2013]

Dear All,

I have 7 subjects(fields ) in my Ms-Access "Marksheet" database of a Class and I want to make a SQL Query that check, if a student fail in any of 3 subjects from 7 subjects the result show "Fail" otherwise he/she will "Pass" in the Examination.
Max Marks:700
Min Marks:231

StdID Sub1 Sub2 Sub3 Sub4 Sub5 Sub6 Sub7 Total Remarks
2345 30 24 14 80 90 87 77 402 Fail
2346 57 57 57 57 58 58 58 402 Pass

Best of Regards....
Mohammad Shahid Shaikh
eziwezi@gmail.c om

[Rabbit]

It sounds like your database is unnormalized. You should normalize the data and it would make the query easier. Here's an article about normalization on this forum: http://bytes.com/topic/access/insigh...ble-structures