Access Coding help

[tpreece01]

Here we go:
I've got an Access 2003 database that records errors.

A table (simplified):
[user] [error]
Each type of error is allocated a points value in a linked table:
[error] [points]

A query pulls this together & shows how many points each user has accumulated over a given period. ie:
user1 6
user2 2
user3 9
user4 12
user5 3

Now I want to grade each user:
0-4 points = grade 1
5-9 points = grade 2
10+ points = grade 3

The results are to be output to a report.

So, whats the best way to have Access work out the grading?

I've got a similar type of question that I'll post separately...

[rojash]

How about:
Select (if points>9 then 3 else if( points>4 then 2 else 1)) as Grade

[vascop]

In Access it should be an expression in a query, and should be:
grade1: IIf([points]>9,3,IIf([points]>4,2,1))

NB IIf is correct and not a typo!

Use expression builder in MS Access

[vascop]

Here's the query with it being used.
http://docs.google.com/Doc?id=dfzbst2k_28897q9 qhk