Edit conditional statements in vba via form.

[matiyas]

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 whole syntax available for user to edit without
actually doing it in vba.
is this possible in vba? i would really appreciate your help.
i have attached an image that will help you understand exactly what i mean.

 

[Pat Hartman]

When you want to give users control over things like this, let them update a table. then your query can join to the table and pull up the name based on the value.

 

[matiyas]

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)
Comment-is the comment in regard to the marks by students in (tbl Comments)

comment: IIf([Marks]>=([Comments.Marks1]),([Comments.Comment]),IIf([Marks]>=([Comments.Marks1]),([Comments.Comment]),IIf([Marks]>=([Comments.Marks1]),([Comments.Comment]))))

 

[pr2-eugin]

Is there any logical reason you are checking the same condition three times? Your last If does not have a False part.. That will throw an ERROR..

 

[matiyas]

i hope this helps you get what i mean.

 

[pr2-eugin]

i hope this helps you get what i mean.

What might help me?

 

[matiyas]

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

 

[pr2-eugin]

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

That made me chuckle, suit yourself.

 

[matiyas]

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.