If statements

[Amy]

I am needing a query that says something to the effect
that if the drop down box in one field says "Mobile" it
multiplies a number in another field by $20, but if it
says "other," it leaves the final outfup field empty. Any
thougthts?

 

[Sangre]

I would recommend the following:



IIf (fieldname = "Mobile", (field2*$20), )

Let me know if this works.