Newbie to querries, grouping results

[C2680mor]

I am creating a query that adds up a series of numbers for each record. This is no problem and i have a column that gives this total.

What I then need to do is take the final number and "grade it". i.e. if the total is between 75 and 100, the grade is "A", if it between 50 and 74 grade is "B".

Any help is appreciated,

Thanks

 

[Newman]

The source for your "txtGrade" field should be this:
=iif([txtTotal]>=75;"A";iif([txtTotal]>=50;"B";iif([txtTotal]>=25;"C";"D")))

 

[C2680mor]

Thanks for the help, but I am getting syntax errors. the code entered is
=iif([Expr1] >=75; "A"

The cursor is flashing on the ;

Thanks for the advice,

Chris

 

[C2680mor]

Replaced with commas and now working fine.

Thanks,

 

[Newman]

Sorry, translation problem. I have the french version of Access which uses ";" instead of ",".
Glad you made it working.