If statements

  • Thread starter Thread starter Amy
  • Start date Start date
A

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?
 
I would recommend the following:



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

Let me know if this works.
 
Back
Top