日期更新功能 [英] Date update fuction

问题描述

我有一个表单，我想计算自上次输入以来所花费的时间。我们有一艘船在两天或有时一周之间填满。我有一个字段来输入容器已满的时间，并希望有填充时间。要更新的字段。我访问的经验非常有限。

如果您需要更多信息，请告诉我


问候


Bob

I have a form that I would like to calculate the time taken since the last input was made. We have a vessel that fills between either two days or sometimes a week. I have a field to input the time the vessel was full and would like to have the "time taken to fill" field to update. I have very limited experience with access.
Please let me know if you require more info

Regards

Bob

推荐答案

我假设您有一个开始时间/日期或至少一个开始日期字段。这将为您提供小时的填充时间，假设您在开始和停止字段中包含时间。

I assume you have a start time/date or at least a start date field. This will give you the fill time in hours, assuming you include time in your start and stop fields.

展开 | 选择 | Wrap | 行号

我有一个时间罐满的字段

这将是下一个新坦克开始填充的同一时间。

如果使用或不使用，每天都会创建一个新记录。

我希望填写时间如果可以在没有时间的情况下开始填充油箱，那么可以在输入油箱全时输入时更新？

希望能够明白这一点吗？


感谢您抽出时间回复


问候

bob

I have a field for "time tank full"
This would be the same time as the next new tank started to fill.
A new record is created every day if it is used or not.
I would like the "time taken to fill" feild to update when the tank full time is input if thats possible without having a time new tank started to fill feild?
Hope thats clear to understand?

Thanks for making time to reply

regards
bob

我根据您的回答假设您不是熟悉访问VBA代码？


missinglinq为您提供了进行此计算的答案。如果您不了解VBA，请告诉我们，以便我们为您提供更好的指导。

I assume based on your answer that you are not to familiar with access VBA code?

missinglinq has given you the answer to do this calculation. If you do not understand the VBA please let us know so that we can give you better guidance.

这篇关于日期更新功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！