Recent content by matiyas

the working SOLUTION. SELECT SM.Student_ID, SM.Students, SM.class, SM.Maths, SM.English, SM.Science, (SELECT GD.Grade FROM tblGrades AS GD WHERE GD.MinMarks = ( SELECT TOP 1 GD.MinMarks FROM tblGrades AS GD WHERE GD.MinMarks <= SM.TotalAverage ORDER BY GD.MinMarks...

Hallo! i have the following database with: -tblGrades-contains: gradeID,Grade,MaxGrade,MinGrade,GPA and comment -tblStudents_marks:StudentId,name and marks in various subjects -qryResults: calculates totals and average in all subjects -qryGrades: Grades the students as per marks and also the...

hallo!! great news, i have found a simple solution. I used a Query: SQL statement: SELECT SM.Student_ID, SM.Students, SM.Marks, GD.Grade FROM tblStudentMarks AS SM INNER JOIN tblGradeDenormalized AS GD ON (SM.Marks>=GD.MinMarks) AND (SM.Marks<=GD.MaxMarks); get database here...

Found solution. using the following simple SQL Statement in a Query. No VBA. SELECT SM.Student_ID, SM.Students, SM.Marks, GD.Grade FROM tblStudentMarks AS SM, tblGradeDenormalized AS GD; i have attached database for any one who might need it.:cool:

thank you once again. i also posted this question in another forum and someone suggested something to do with DLookup() and a non-equi join.....am trying to see if it will work for me. the thread is here: http://www.accessforums.net/access/customize-function-form-37552.html#post187865

thank you very much madefemere, i have called the function in a query and it works fine. am sorry to bother you too much but i am new to vba,i was wondering how i will make this function available for the user in a form, so that they can edit it. you see different institutions might have variant...

it seems to be confusing more and more. just forget it, thanks anyway.

i hope this helps you get what i mean.

i did that but it gives wrong results, instead of using the table (comments) to determine the correct results it gives results of the comments table instead. in the query i used the following formula. Note: Marks- is the students marks. (tbl Marks) Marks1-marks to be compared to. (tbl Comments)...

okey, let me make it as simple as possible. this is what i want to achieve. I have a table of marks of student, a query that calculates totals and a form that displays results. on the query, i have an if statement. comment:IIf([Marks]>=80,"good",IIf([Marks]>=50,"fair",IIf([Marks]>=40,"Work...

this is what i want to achieve. I have a table of marks of student, a query that calculates totals and a form that displays results. on the query, i have an if statement. comment:IIf([Marks]>=80,"good",IIf([Marks]>=50,"fair",IIf([Marks]>=40,"Work harder"))) So i want to be able to make the...

Hallo, please help me solve this headake. can it be possible to customize an if function?? syntax. iif ( condition, value_if_true, value_if_false ) i mean enable the user to change condition, value_if_true, value_if_false in a form. thanks in advance.

was looking for this. Thanks. John Big Booty. in a query, i have a field "Grade:" it grades according to the below criteria. i want user to edit the constant marks in a form i.e 80,70,65,60,55,.... can this be possible? Grade...

:eek: :o:) madefemere, SIR! U HAVE SAVED MY LIFE! EXACTLY WHAT I WANTED WITH A SUPER BONUS! Almighty Bless You.

okey thank you very much madefemere :cool:, that solves part of the problem. However,I would like the user to insert random variables...more like a parameter query on the criteria..like the user could put >50, <=29...etc BUT still maintain the Rank and based on the new filter...