自动年龄计算 [英] Automatic age calculation

问题描述

大家好，

感谢上一个问题的所有帮助。我有另一个。有人知道如何让访问自动计算年龄并在输入人的出生日期时显示在字段中吗？这甚至可能吗？任何帮助将不胜感激。谢谢。

Hello guys,
Thanks for all the help with the last question. I have another one. Does anyone know how to let access automatically calculate age and display in field when the person''s date of birth is entered? Is that even possible? Any help would be greatly appreciated. Thanks.

推荐答案

嗨。 此是微软对此主题的评论

Hi. this is what microsoft has to say on this subject

嗨。 此是微软对此主题的评论

Hi. this is what microsoft has to say on this subject

谢谢Willa，我检查了网站，但我真正想做的是根据计算机系统的日期来计算人的年龄。因此，我将进入该人的生日，访问权限应使用系统的日期来计算和显示该人的年龄。我不确定这是否可行，但仍在阅读一些材料。再次感谢。

Thank you Willa, I checked the site but what I actually want to do is to calculate the persons''s age based on the computer system''s date. So I will enter the person''s birthday and access should use the system''s date to calculate and display the person''s age in years. Am not sure if this is possible but am still reading through some materials. Thanks again.

您只需要在表单上加上datediff来计算年龄。函数Now（）返回系统日期和时间。

You just need to put datediff on your form to calculate the age. The function, Now(), returns the system date and time.

展开 | 选择 | Wrap | 行号

这篇关于自动年龄计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！