将记录复制到Access 2007中的其他表 [英] Copy record to a different table in Access 2007

问题描述

我希望能够将当前记录复制到另一个表中。我正在跟踪捐款，我每年都会创建一个新的捐款表 - 有些记录会相同或略有不同。我曾经在Access 2003中使用宏来执行此操作，但它在Access 2007中的工作方式并不好用，而且我找不到其他可行的命令。我将不胜感激。

I would like to be able to copy the current record to a different table. I am tracking donations and I create a new table of donations each year--some of the records will be the same or slightly different. I used to do this with a macro in Access 2003, but it doesn''t work in Access 2007 the way it was, and I can''t find other commands that will work. I would appreciate any help.

推荐答案

为什么不将所有年份的所有数据存储在一个表中。有一个年份的字段，然后运行一个只选择您想要查看的年份的查询。这样可以节省重复工作，并将数据库发挥到最大潜力。

Why not just store all data for all years in one table. Have a field for year, and then run a query that selects only for the year you want to see. This saves duplicating work and would use the database to its best potential.

Hi Cindy，


errol999在这里是正确的。它违反了公认的数据库设计规则，使多个表存储相同的信息。如果您的目标是从数据中运行报告，则只需创建一个查询，找出您想要信息的年份，然后根据该查询生成报告。


Pat

Hi Cindy,

errol999 is correct here. It violates accepted database design rules to have multiple tables that store the same information. If your goal is to run reports off your data, you would simply create a query that picks out the year you want information for, and then base your report on that query.

Pat

Cindy，


虽然我也回应其他人所说的话（参见规范化和表结构以获取更多信息），我想知道您的问题是否只涉及将数据从一个表移动到另一个表如果没有，也许你可以更清楚地解释一下，我们也许可以提供一些帮助。

Cindy,

While I also echo what the others have said (See Normalisation and Table structures for further info), I wonder if your question relates simply to moving data from one table to another simply due to its year.

If not, perhaps you could explain a little more clearly and we may be able to be of some assistance.

这篇关于将记录复制到Access 2007中的其他表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！