Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. yaksdogs

    Iff Statement Problem

    I just wanted to let you know that did it and the calculations seem to be working. Thanks for much for your help. Have a great holiday.
  2. yaksdogs

    Iff Statement Problem

    These are the items checked: Visual Basic for applicaitons Microsoft Access 9.0 Object Library OLE Automation Microsoft ActiveX Data Objects 2.1 Library Does this help?
  3. yaksdogs

    Iff Statement Problem

    Ok I tried it now I am getting an error Undefined function in "IIf" statement. What I am I doing wrong here?
  4. yaksdogs

    Iff Statement Problem

    How would you do it if it were to affect more than one field? I have been trying to do it this way? =Sum([ASSESSED_VALUE]),iif([included_value]=0,0,[tot_av]) There are about 4 fields that this affects on one report.
  5. yaksdogs

    Iff Statement Problem

    A little info here. I have a report that will show duplicate values in but here is the kicker those need to be shown but not added into the total. I have created a check box labeled (included_value). This report also has quite a bit of divide by zero. So in the subtotal field have...

Part and Inventory Search

Back
Top