Does anyone have an idea how to extract the first paragraph of a memo field of a table to be used in a query? Thanks...

NewField: IIf(instr([MemoField],chr(13)), left([MemoField],instr([MemoField],chr(13))-1), [MemoField])
.

Would you please explain the expression a little, since I am getting an error when I write this to a new field in a Query. Memofield is the field that I want to collect the first paragraph I guess. However, chr(13) is the one I was puzzled. The error is about the comma before the first chr(13). Thanks a lot...

I tried the formula and it worked perfectly.
Very nice indeed Jon K!!

Only after did I change the commas to semi comma, it worked. Thanks Jon K:)

I think whether you should use comma or semi colon as the argument separator in a function entirely depends on the version of Windows you are using. Most Windows versions use comma.

^