Breaking memo field apart

[John]

Hi

I need to break a memo field apart by the individual lines of text it has. I
only need the last two lines. How do I do this in a query?

Thanks

Regards

[Allen Browne]

Use InstrRev() to locate the occurrance of vbCrLf twice (since you want the
last two lines), and then Mid() to pickup the text from that point.

Note:
1. Requires Access 2000 or later.
2. If you are not doing this in code, use Chr(13) & Chr(10) instead of
vbCrLf.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:3f**********************@news.dial.pipex.com. ..

I need to break a memo field apart by the individual lines of text it has. I only need the last two lines. How do I do this in a query?