我有两个表一个包含2013年数据，一个包含2014年数据（这些是非常的 [英] I have two table one contain 2013 data and one will contain 2014 data (these are very

问题描述

我有查询，表单和代码，用于访问2013表格中的报告。用户现在也将数据输入到2104表中。我现在需要添加2014表，并让用户能够访问任一表。我很擅长这个。我该怎么做？

I have queries, forms and code built to access reports from the 2013 table. Also users will now enter data into 2104 table. I now need to add 2014 table and have users be able to access either table. I am pretty new at this. How do I go about doing this?

推荐答案

数据必须在两个不同的表中吗？为什么不添加一列来描述数据的年份。然后每个查询或表单都可以询问正在处理的是哪一年。


Jim

Must the data be in two different tables? Why not add a column to describe what year the data is for. Then each query or form could ask what year is being processed.

Jim

@jimatqsi


Jim

表是非常大的158,955条记录，这只是2013年所以我们会加倍那。我可以参考一个日期字段。我有一个用户可以运行报告的表单，我需要它们能够运行两年，wat是最好的方法，只要你不认为表格太大。

@jimatqsi
Jim
Table are very large 158,955 records, that is just 2013 so we would double that. There is a date field which I could reference to. I have a form where the user can run reports and I would need them to be able to run both years, wat is the best way to do this providing you don''t think the tables will be too large.

如果要检索相同的信息，只需复制每个查询，将查询的过滤器更改为2014。表。


对于用户需要访问两个表的查询，只需在查询中包含表和必填字段。


至于代码，我们怎么知道它在做什么，然后告诉你如何解决它 - 如果我们不知道它在做什么？


你做的事情重新抓住日期的差异。如果您觉得它很重要，请创建相同的表格结构/查询/代码，并将其格式化为2014年，或者2013年和2014年，当您正在做的事情需要来自两个表格的数据时。


您拥有所有部分，只需更改标准/表格结构。

If you are retrieving the same information, just make a copy of each query change the filter for the queries to the "2014" table.

For queries where your users will need to access both tables, simply include both tables and the required fields in the queries.

As for the code, how are we supposed to know what it is doing, and thus tell you how to fix it - if we have NO idea what it is doing?

The thing you''re getting caught up on is the difference in dates. If you find it essential, create the same exact table structure/queries/code and format it for 2014, or both 2013 and 2014 when what you''re doing requires data from both tables.

You have all of the pieces, it''s only a matter of changing the criteria / table structure.

这篇关于我有两个表一个包含2013年数据，一个包含2014年数据（这些是非常的的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！