一次更新一条记录 [英] Updating one record at a time

问题描述

我正在尝试将Table1中的第一个字段添加到Table2中。在表2中使用此记录，我正在运行一组查询以获取最终结果。一旦完成第一条记录的查询，我希望查询运行到我的下一条记录，直到EOF。当然，我希望使用表单上的命令按钮进行自动化。

任何想法？任何帮助表示赞赏。

I am trying to add the first field from Table1 to Table2. Using this record in Table2, I am running a set of queries to get my end result. Once the queries are completed for the first record, I want the queries to run for my next record until EOF. Ofcourse, I want this automated using a command button on a form.
Any ideas ? Any help is appreciated.

推荐答案

我正在尝试添加第一个字段表1至表2。在表2中使用此记录，我正在运行一组查询以获取最终结果。一旦完成第一条记录的查询，我希望查询运行到我的下一条记录，直到EOF。当然，我希望使用表单上的命令按钮进行自动化。

任何想法？任何帮助表示赞赏。

I am trying to add the first field from Table1 to Table2. Using this record in Table2, I am running a set of queries to get my end result. Once the queries are completed for the first record, I want the queries to run for my next record until EOF. Ofcourse, I want this automated using a command button on a form.
Any ideas ? Any help is appreciated.

我可以澄清一下吗？你真的是指第一个字段，或者第一个记录吗？

它实际上是第一个记录中的第二个字段。


谢谢。

its actually the 2nd feild in the first record.

Thanks.

它实际上是第一个记录中的第二个。

its actually the 2nd feild in the first record.

嗯...对不起，也许这只是我，但我很难理解你想要表现的过程。 />

我最好能解决，当您单击表单上的按钮时，您希望Access为Table1中的每条记录运行一堆查询（未提供详细信息）。基本上，其中一个查询将是一个动作查询，它​​将记录复制（或移动？）到Table2。


这听起来是对的吗？如果是这样，这些查询中的每一个都应该向用户提供输出，或执行某些更新，或者是什么？

Um... sorry, maybe it''s just me, but I''m having trouble understanding the process you''re trying to perform.

As best I can work out, when you click a button on your form, you want Access to run a bunch of queries (details not provided) for each record in Table1. And basically, one of those queries will be an action query which will copy (or move?) the record to Table2.

Does this sound about right? If so, is each of these queries supposed to provide output to the user, or perform some update, or what?

这篇关于一次更新一条记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！