自动标记已丢失一段时间的用户 [英] Auto flag users that have been missing for a period of time

问题描述

你好，
这是我的情况.我有一个访问数据库，其中包含我组织的客户的返回日期.我需要找到一种方法来自动标记那些错过了返回日期长达一周的信息，然后再将那些丢失了更长时间的信息标记出来.
欢迎任何指针.

在此先感谢！

Hello,
this is my scenario. I have an access database with return dates for clients of my organization. I need to find a way of auto flagging those that have missed a return date by upto a week and then those that have been missing for an even longer while.
Any pointers are welcome.

Thanks in advance!

推荐答案

创建一个日期变量，该变量在每次登录时都会更新，并且在需要的时间段内将其与[TODAY]进行比较.应用例如颜色变化，使其突出显示.

此处 [ ^ ].

Create a date variable that is updated each time they log on, and have that date compared with [TODAY], if it over the required period apply, say, a colour change, so that it is highlighted.

Here[^].

这篇关于自动标记已丢失一段时间的用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！