如何在查询中减去毫秒（以文本格式）？

本文介绍了如何在查询中减去毫秒（以文本格式）？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有一个计时申请表。现在我的客户想要添加毫秒精度。 我有两个叫做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 | 行号