Select first line of memo field

I am looking for a way to select only the first line of memo field, quite self explanatory but this is what I am after.

This is the first line
This is the second line
This is the third line

So I would just end up with

This is the first line

Thanks
daverichardsonAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
jerryb30Connect With a Mentor Commented:
OK. SELECT Left([Data]![Description],InStr([Data]![Description],Chr(13) & Chr(10))-1) AS _Description
FROM Data;
0
 
jerryb30Commented:
Select left(memofield, instr(memofield, vbCRLF) as firstLine from yourTable
0
 
daverichardsonAuthor Commented:
i cant get it to work using vbCRLF, it asks me for the vbCRLF value. If i use the following it puts a carriage return at the end of the line.

SELECT Left([Data]![Description],InStr([Data]![Description],Chr(13) & Chr(10))) AS _Description
FROM Data;
0
 
daverichardsonAuthor Commented:
Thanks, i also got it to work with:
SELECT Left([Data]![Description],InStr([Data]![Description],Chr(10))) AS _Description
FROM Data;
0
All Courses

From novice to tech pro — start learning today.