Please help me..thanks!!!

[cacingwong]

i want to make a query based on the ranking of the student. For example, student who ranking 1 to 14 will assign to class A. Student who ranking 15 to 29 will assign to class B. Student who ranking 30 to 45 will assign to class C .



when i key in the queries. ClassNumber: IIf([Ranking]>=1 And [Ranking]<=14,"A",IIf([Ranking]>=15 And [Ranking]<=29,"B",IIf([Ranking]>=30 And [Ranking]<=45,"C")))
it just show #error..how can i do??

[amrut]

There is field named ClassNumber in your tables. Why do you need it ? Are you trying to update the table based on ClassNumber field or update it ?
Try this :
AssignedToClass : IIf([Ranking]<15,"A",IIf([Ranking]<30,"B","C"))

[cacingwong]

There is field named ClassNumber in your tables. Why do you need it ? Are you trying to update the table based on ClassNumber field or update it ?
Try this :
AssignedToClass : IIf([Ranking]<15,"A",IIf([Ranking]<30,"B","C"))

thank you amrut, can i have your email. i need your helps. actually this is my assignment in university. My lecture ask me to do class management system. The purpose is to register student and classify them into class based on their result. Need summit on next week. I am so stress about it...thanks!