MS Access Help

[OuiKikUrAzz]

OK two things I want to create hoping someone can help me with.

In access I want to create a expression where:

If field1 = this THEN Multiply by 25% of field2
OR
If field1 = that THEN multiply by 10% of field2



Second expression:

If field = BB then output Blah
or
If field = CC then output Cardbon Copy
or
If field = RE then output Idiot

etc.

Can anyone help me with this? Thanks

 

[SQL]

Are talking about doing this in a query?

If so sounds like you can do most of it with IIF.

 

[OuiKikUrAzz]

i'm in form view, using expression builder