Index in a Query??

[Billionz]

Hi,

I have a field (Field A) that always has the numbers 1 thru 8 in it.

The next field is just a numeric field 1 thru 100 (Field B).

In the field I would like to create (Field C) I need it to add "Field B to a calculated number from (Field A).

That calculated number would be ( IF the number in "Field A" is 1 then it would be 0 -- OR if the number in "Field A"is 2 then it would be .14 -- and so on to number 8)

1=0
2=.14
3=.21
4=.28
5=.35
6=.42
7=.49
8=.56

So if Field A was 3 and Field B was 32 then Field C would be 32.21 (Field B + Calculated number from Field A)

Is there a way to do this ??

Thanks for your help.

Bill

 

[Tiro Cupidus]

Field C: IIf([fieldA]=1,0,[fieldB]*.07)