Recent content by bobreyn1990

Agreed - Im still playing around with this. Hopefully I can get it to work. This issue may be in the soruce file itself so Im looking in to that

Hi - Your modified formula cleared up the errors but it looks like this: IIf(InStr([Notes],Chr(13))=0,[Notes],Left([Notes],InStr([Notes],Chr(13))-1)) Access didnt like the ") at the end for some reason - invalid string? [Notes] is the field that has the text entries so next to the...

Hi CJ - I did, yes and I am seeing a few errors so thought that was it. Im seeing #Func! for some fields...others seem to be pulling ok :) Is the 13 in the formula counting the date in the brackets? example: this text string: [3/26/2015:CMB] Sent email requesting estimate on when GHR expects...

Hi guys - thanks. Let me add a little clarity In the case I described, the text Im looking to pull would likely be of varying lengths. Example In 1 record the text may be 15 characters long....the next...maybe 9. would this "left(mymemo,instr(mymemo,chr(13))-1)" acocunt for the varying...

Hi All - lots of info in here but am hoping to see if this can be done someplace in Access - thinking a query most likely. I have a text field in a Table and on a Query called "Notes" In that field that has data like below: [04/02/2015:BD] Project is to be assessed by Solutions Planning...