Query for a memo field

  • Thread starter Thread starter giannis
  • Start date Start date
G

giannis

I need a query that take the first row of a memo field and
put this in an other field (for all the records).
How can specify the first row of a memo ?
 
Thanx very mutch !!! I used the query :
UPDATE table SET field = Left([memo],InStr([memo],Chr(13)+Chr(10))-1)
and all are done !!!!


Arvin Meyer said:
The first row is not defined in a memo field unless there is a carriage
return and line feed (vbCrLf) or if used in a query Chr(13) & Chr(10).
Unless you can use that, or some other method to define what a first row is,
you won't be able to extract it.

If you can use it, simply wrap an InStr() function with the Left() function
(aircode):

NewField: Left([MemoField], InStr([MemoField], Chr(13) & Chr(10)))
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

giannis said:
note : only if the field is empty
Click to expand...
Click to expand...
 
Back
Top