从查询中追加 [英] appending from a query

问题描述

您好，


我已经编写了一个查询文本发送票证的查询在一个名为notes的表中。如果找到，它将输出键值引用的名称和地址。这样做完成并且工作正常;但是我需要更改该记录的后续日期，或者附加备注字段以添加发送的票证字样。对于每条记录。这是否可以使用标准查询？

解决方案

你好，


我写了一个查询来测试文本发送票证在一个名为notes的表中。如果找到，它将输出键值引用的名称和地址。这样做完成并且工作正常;但是我需要更改该记录的后续日期，或者附加备注字段以添加发送的票证字样。对于每条记录。这是否可以使用标准查询？

您可以发布查询的SQL，我们会看到吗？

这是查询的sql代码到目前为止。


SELECT custlist1.CO_NAME，custlist1.CONTACT，custlist1.ADDRESS1，custlist1.ADDRESS2，custlist1.ADDRESS3，custlist1.ADDRESS4，custlist1.ADDRESS5，custlist1.POST_CODE

FROM custlist1 INNER JOIN（[其他地址] INNER JOIN注意ON [附加地址] .Customer_code =注释。[客户代码]）ON custlist1.SHORT_NAME =注释。[客户代码]

WHERE （（（注释。[跟进日期]）>＃5/1/2006＃）和（（Notes.Notes）喜欢*发送票证*））;



它正确地找到包含文本发送票证的记录，但我仍然需要它将发送的票证附加到备注中的同一记录。

< blockquote>

以下是目前查询的sql代码。


FROM custlist1 INNER JOIN（[其他地址] INNER JOIN注意ON [其他地址] .Customer_code = Notes。[客户代码]）ON custlist1.SHORT_NAME = Notes。[客户代码]

WHERE（（（注释。[跟进日期]）>＃5/1/2006＃ ）和（（Notes.Notes）喜欢*发送票证*））;



它正确地找到包含文本''发送票''的记录，但我仍然需要它将发送的票附加到票据中的同一记录中。

先备份你的桌子...


然后看看这是否有用：

展开 | 选择 | Wrap | 行号

Hi there,

I have written a query that will test for the text "send tickets" in a table called notes. If found it will then output the names and addresses referenced by the key value. This is done and works fine; however I need to either change the follow up date for that record OR append the notes field to add the words "Tickets sent" for each record. Is this possible using a standard query?

解决方案

Hi there,

I have written a query that will test for the text "send tickets" in a table called notes. If found it will then output the names and addresses referenced by the key value. This is done and works fine; however I need to either change the follow up date for that record OR append the notes field to add the words "Tickets sent" for each record. Is this possible using a standard query?

Can you post the SQL for the query and we will see?

Here is the sql code for the query so far.

SELECT custlist1.CO_NAME, custlist1.CONTACT, custlist1.ADDRESS1, custlist1.ADDRESS2, custlist1.ADDRESS3, custlist1.ADDRESS4, custlist1.ADDRESS5, custlist1.POST_CODE
FROM custlist1 INNER JOIN ([additional addresses] INNER JOIN Notes ON [additional addresses].Customer_code = Notes.[Customer Code]) ON custlist1.SHORT_NAME = Notes.[Customer Code]
WHERE (((Notes.[follow up date])>#5/1/2006#) AND ((Notes.Notes) Like "*send tickets*"));


It correctly finds records that contain the text ''send tickets'' , but I still need it to append ''tickets sent'' to the same record in notes.

Here is the sql code for the query so far.

SELECT custlist1.CO_NAME, custlist1.CONTACT, custlist1.ADDRESS1, custlist1.ADDRESS2, custlist1.ADDRESS3, custlist1.ADDRESS4, custlist1.ADDRESS5, custlist1.POST_CODE
FROM custlist1 INNER JOIN ([additional addresses] INNER JOIN Notes ON [additional addresses].Customer_code = Notes.[Customer Code]) ON custlist1.SHORT_NAME = Notes.[Customer Code]
WHERE (((Notes.[follow up date])>#5/1/2006#) AND ((Notes.Notes) Like "*send tickets*"));


It correctly finds records that contain the text ''send tickets'' , but I still need it to append ''tickets sent'' to the same record in notes.

Backup your table first ...

Then see if this will work:

Expand|Select|Wrap|Line Numbers

这篇关于从查询中追加的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！