Recent content by crjackson

  1. C

    Question Need help with iif/left statement not returning false argument.

    Yep, I do remember doing that in Excel just the other day. Don't know why I didn't remember it for Access. Thanks again Plog!!!
  2. C

    Question Need help with iif/left statement not returning false argument.

    Plog, Thank you Typical me, overcomplicating things. Just for kicks and giggles, how can I get the original formula to work. In case I wanted to use it in a different context.
  3. C

    Question Need help with iif/left statement not returning false argument.

    I'm a self taught novice so I'm really not sure what I'm doing wrong. Any suggestions are welcome. I'm trying to derive the month in digits from a date/time stamp field. Any month between 10 and 12, I need the first 2 digits but anything <=9 is only 1 digit. MONTH: IIf(Left([LOAD TO SKU LEVEL...
  4. C

    No return on false argmument in iif/left statement

    I'm a self taught novice so I'm really not sure what I'm doing wrong. Any suggestions are welcome. I'm trying to derive the month in digits from a date/time stamp field. Any month between 10 and 12, I need the first 2 digits but anything <=9 is only 1 digit. MONTH: IIf(Left([LOAD TO SKU LEVEL...
See more
Back
Top Bottom