Search results

  1. G

    Nesting Iif statement with Mid and InStr Functions

    In Access 2010, I am using the following to add a hanging indent to the detail section of a 3 column report. =IIf(Len([KeyArrRpt])<=45,[KeyArrRpt],Left([KeyArrRpt],InStr(45,[KeyArrRpt]," ")) & Chr(13) & Chr(10) & " " & Mid([KeyArrRpt],InStr(45,[KeyArrRpt]," ")+1)) I get the...
  2. G

    Hi

    Hi, I live in Idaho and work for a print music/musical accessories dealer. I've been working in Access off and on for almost ten years now, but haven't got a lot of experience in the VBA and SQL sides of things. This forum has been my go-to forum for getting hard-to-find answers. I look forward...
Back
Top Bottom