Query for a memo field

[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 ?

 

[giannis]

note : only if the field is empty

 

[giannis]

note : only if the field is empty

 

[Joseph Meehan]

I don't believe it is possible. One of the negatives about memo fields.

 

[giannis]

Thanx very mutch !!! I used the query :
UPDATE table SET field = Left([memo],InStr([memo],Chr(13)+Chr(10))-1)
and all are done !!!!

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

note : only if the field is empty