Memo Field with blank first line

[steve]

I have a memo field whose data has a blank line as the first line in the
field. The data starts on the second line. I got the following query to
return the records, I just cant figure out how to update the field to remove
the blank line. The line that looks blank contains the ascii characters
Chr(13) Chr(10).

SELECT [ORDERS TABLE].ORDER
FROM [ORDERS TABLE]
WHERE (((Left([order],1))=Chr(13)));

TIA for the help.

Steve

 

[Allen Browne]

Change the query to an Update query (Update on Query menu.)
Access adds an Update row to the grid.

In the Update row under the [order] field, enter:
Mid([Order],3)
Run the query.

Note that ORDER is not a good name for a field, since it is a reserved word.
For a list of names to avoid, see:
http://allenbrowne.com/AppIssueBadWord.html