本文介绍了如何在查询中减去毫秒(以文本格式)?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个计时申请表。现在我的客户想要添加毫秒精度。 我有两个叫做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 | 行号
更多推荐
如何在查询中减去毫秒(以文本格式)?
发布评论