查询/报告中的备注字段 [英] Memo field in queries/reports
问题描述
我有一个备忘录字段,每次我在字段中添加新文本时都会添加新行(回车)和日期戳。 但是,当我尝试使用查询从备注字段中提取文本时 - 对于报表,它只显示第一行
的文本。 也就是说,如果备注字段如下所示:
第1行文本(日期)
第2行文本(日期)
第3行文本(日期)
当我运行查询时,我得到的是:第1行文本(日期
它不会提取第2行或第3行,并且就此而言不会显示最后一个")"。
我如何解决这个问题?
或许使用REPLACE语句...用制表符替换所有回车符(Char(13))和换行符(Char(10)) Char(9))?
假设备注字段名为MemFld
选择替换(Memfld,char(13),char(9))从mytable
您可能希望对char(0)和char(5)以及任何其他char执行此操作,因此可能只返回ansi标准字符az,AZ和0-9的函数
I have a memo field that when used adds a new line (carriage return) and a date stamp every time I had some new text to the field. However, when I try to extract the text from the memo field with a query - for a report, it only displays the first line of text. That is, if the memo field looks like this:
Line 1 text (date)
Line 2 text (date)
Line 3 text (date)
And when I run a query, all I get is: Line1 text (date
It won't extract line 2 or 3, and for that matter won't display the last ")".
How do I get around this?
Perhaps with a REPLACE statement... replace all the carriage returns (Char(13)) and line feeds (Char(10)) with a tab (Char(9))?
Assume Memo field is called MemFld
Select Replace(Memfld,char(13),char(9)) from mytable
You may want to do this for char(0) and char(5) and any other char so perhaps a function that only returns ansi standard characters a-z, A-Z, and 0-9?
这篇关于查询/报告中的备注字段的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!