I'm trying to run a conditional statement in an access query. The options would be:
0-100 5
101-200 10
201-300 15
ect...something like that.
I tried IIF(([FIELD]>201),15,IIF([FIELD]>=101) and ([FIELD]<201),10))
But it's not working...any help would be great
0-100 5
101-200 10
201-300 15
ect...something like that.
I tried IIF(([FIELD]>201),15,IIF([FIELD]>=101) and ([FIELD]<201),10))
But it's not working...any help would be great