Sorting a memo field

S

Steve King

Create a query with a new column displaying the memo field
data up to the first carriage return. This generally
requires a function to return the data.

Public Function FirstLine(memodat As String) As String
Dim tmpmemo As String
tmpmemo = Left(memodat, 50)
 
Top