如何在查询中减去毫秒（以文本格式）？ [英] How to subtract milliseconds (in text format) in a query?

问题描述

我有一个计时申请表。现在我的客户想要添加毫秒精度。

我有两个叫做timestart和timefinish的字段。

我设法用一个按钮从主窗体（RaceF）到子窗体（timesf）添加毫秒等。一个表（TimeT）使用它：

I have a timing application. Now my clients want milliseconds accuracy added to it.
I have two fields called timestart and timefinish.
I manage to add milliseconds etc with a button from main form (RaceF) to subform (timesf) in the start field in a table (TimeT) using this:

展开 | 选择 | Wrap | 行号

推荐答案

我认为没有简单的方法可以实现这一点两个时间值都是TEXT，并包含一个毫秒组件。我假设经过句号（。），51,92,78等的所有数字分别代表毫秒，即：51毫秒，92毫秒和78毫秒。这个假设是正确的吗？

I see no easy way to accomplish this since both Time Values are TEXT, and contain a Millisecond Component. I''m assuming that all digits past the Period (.), 51, 92, 78, etc. represent Milliseconds, namely: 51 Milliseconds, 92 Milliseconds, and 78 Milliseconds respectively. Is this assumption correct?

嗨Adezi先生。是的，我认为就是这样。可以不将其添加到日期字段中。也许？我试过没有成功。

我在互联网上遇到了这个代码。它来自一个VB 6网站，它以某种方式给我一个毫秒值 - 在我的应用程序中特定类型的竞赛需要，目前只有几秒钟。我只需要在这个例子中减去开始和结束时间。

关于如何将毫秒添加到datefield的任何其他建议。在访问。

Hi Mr Adezi. Yes i assume it is that. Can one not add it to a "date field" perhaps? I have tried with no success.
I came across this code on the internet. It was from a VB 6 website, and it somehow gives me a millisecond value - is required for a specific type of race in my application that is currently only in seconds. I just need to subtract the start and finish times in this instance.
Any other suggestions on how to add milliseconds to a "datefield" in access.

我刚刚取出日期

I have just taken out the date

展开 | 选择 | Wrap | 行号

这篇关于如何在查询中减去毫秒（以文本格式）？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！