比较MS Access中两个表中的时间 [英] Compare times in two tables in MS Access

问题描述

我有2个表，日期和时间作为单独的字段。表A每小时记录一次，表B每天记录一次（不是小时）。如何比较表A中与表B中的记录尽可能接近的记录中的数据？

I have 2 tables with date and time as separate fields. Table A has records every hour on the hour, Table B has records once a day (not on the hour). How do I compare data from the record from Table A that corresponds as close as possible to the record from Table B?

推荐答案

表格是否相关？


您在寻找什么样的产品？它基本上是表B中的日期时间（以及查询左侧列中的任何其他相关表B信息以及查询右侧列中表A中最接近的日期/时间和相关数据吗？


Phil

Are the tables related?

What sort of output are you looking for? Is it the basically the date time from Table B (and any other relevant table B information in the left hand columns of a query and the closest date/ time & relevant data from Table A in the right hand columns of the query?

Phil

我试图使用Date字段加入表格。


表格是数据来自两个不同的仪器，我需要使用表A中的参数和表B中的参数在相同的日期和时间进行计算

I have tried to join the tables using the Date field.

The tables are data from two different instruments and I need to use a parameter from Table A and a parameter from Table B at the same date and time to perform a calculation

Hi Lisa。


为什么不试着准确解释你想要实现的目标，并在这两个表中包含一些示例数据。你可以从样本数据中进一步解释你所期望的结果可能会形成你想要的想法。


我们可以提供一大堆建议，但是如果没有清楚地了解你之后会有什么建议，他们将主要是刺伤了他很黑。


给你一些帮助你理解的东西（时间间隔重叠（MS Access 2003））是一个很有帮助的链接。

Hi Lisa.

Why don''t you try to explain exactly what you''re trying to achieve and include some example data from the two tables. You can further explain what you expect as a result from the sample data and we would probably be able to form an idea of what you want.

We can offer a whole bunch of suggestions, but without a clear understanding of what you''re after they will mainly be stabs in the dark.

To give you something to help you understand here (Time Interval Overlapping (MS Access 2003)) is a hopefully helpful link.

这篇关于比较MS Access中两个表中的时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！