January 2002
Beginner
576 pages
13h 23m
English
One solution is to use a string of nested IIF functions in an update query. It would look like the following:
IIF([Incurred]>=1 and ([Incurred]<=500,[Level]=1,IIF([Incurred]>=501 and [Incurred]<=1000,[Level]=501,IIF([Incurred]>=1001 and [Incurred]<=5000, [Level]=1001,IIF([Incurred]>=5001 and [Incurred]<=10001,[Level]=5001, IIF([Incurred]>=10001 and
[Incurred]<=25000,[Level]=10001, IIF(Incurred]>=25001 and [Incurred]<=50000,[Level]=25001, IIF([Incurred]>50000,[Level]=50001
This solution has ...