I have a query with these fields
Field 1 Amount
Field 2 Type (1 2 3 4 5 6)
Field 3 Size (1 2)
I want to calculate the amount in a new field like this
If type =1 and Size =1 then amount=amount*10
If type =2 and Size =1 then amount=amount*8
If type =3 and Size =1...