Search results

thanks.got it.

Thank you so very much as using these codes in my query, i was able to get the required result.here is how i write my query SELECT student_id,subject, total_marks,marks_obtained, (SELECT Count(*) FROM test_tab As Q WHERE Q.student_id = test_tab.student_id) AS Subj_Count, (SELECT Count(*) FROM...

it almost has worked but there is a little problem. it is showing me the sum of marks obtained of all the students for the subjects in which they get passed while i want the total_marks_obtained of only those students who get passed in every subject in which they appeared for. for ecample if i...

i tried the query but it is giving when i run it, it gives the following error Syntax error (missing operator) in query expression 'total_marks_obtained: DSum("[marks_obtained]", "test_tab", "100*[marks_obtained]/[total_marks]>=33 AND Student_id = " & student_id) FROM test_tab'. looking...

i tried this query SELECT student_id, subject, total_marks, marks_obtained,total_marks_obtained= DSum("[marks_obtained]", "test_tab", "100*[marks_obtained]/[total_marks]>=33") from test_tab

i studied DSUM function and searched it on net..i am not sure if it can serve my purpose. i try to use it with SELECT but it isnt working

i need some help in an sql query in Access 2007 although i have done it in Oracle . to understand the problem you have to take the pain of reading this whole thing :) i have a table in this format student_id | subject | total_marks | marks_obtained 1 Math 100...