Search results

  1. N

    If-Then-Else Statement

    THANK YOU SmallTomato!! It worked like a charm.
  2. N

    If-Then-Else Statement

    Sooo....now I am getting #DIV/0! in a few cells. I tried adding an IIf statement that read IIf[HOURS_WORKED]or[GOOD_QTY]="0","0". I put it as part of the nest, by itself, even added [HOURS_WORKED]/[GOOD_QTY]or[GOOD_QTY]/[HOURS_WORKED]at the end of the statement, as I found it on the help area...
  3. N

    If-Then-Else Statement

    Thank you guys so much. This worked perfectly. I did not realize I could write it that way, or what a nested IIf was. You guys rock!!
  4. N

    If-Then-Else Statement

    Thanks for you replies, but I really don't know what you are saying. Like I said, I have been doing this for a month. Here is what I have in the Expression Builder. What is wrong with it(I am sure a lot!)? If [RUN_TYPE] = "PCS/HR" Then [GOOD_QTY]/[HOURS_WORKED] Else If [RUN_TYPE] = PCS/MIN"...
  5. N

    If-Then-Else Statement

    I have been using Access for about a month and I have figured out through trial and error how to do a simple "If-Then" statement. I am now trying to add a third option to the mix and this has been my down fall. I am looking for the following formula for Access 2010 query: If = "PCS/MIN", then...
Back
Top Bottom