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??