帮助在出生日期使用日期 [英] Help using dates as in birthdates
本文介绍了帮助在出生日期使用日期的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我是一名电枢访问程序员,我尽力设计自己的数据库,因此非常感谢您的耐心和详细说明。
我在我的参与者中生日了。表格
1)如何设置标准,以便我只在表格中看到比x
2)更旧的人,如何添加一个计算字段,以便它显示该人今天的年龄?
解决方案
有人在那里帮忙吗?
我是一个电枢访问程序员,我尽力设计自己的数据库,所以你的耐心和详细的说明非常感谢。
我我的参与者中有生日。表格
1)如何设置标准,以便我只看到超过x
的人
这样会使用查询完成。假设birthdate是字段名称,年龄限制是35.
展开 | 选择 | Wrap | 行号
制作文本框的控件来源
代码:
= DateDiff(''yyyy'',现在(),[生日])
----------------------
谢谢
2个问题,
1)为什么在年龄之前有一个减号?
2)它只根据出生年份来计算它,这意味着它并不总是准确的(它最多可以休息364天)
I am an armature access programmer trying my best to design my own database so your patience and detailed instructions is much appreciated.
I have birthdates in my "participants" table
1) How do I set the criteria so that I only see people that are older than x
2) in a form, how do I add a calculated field so that it shows me how old the person is as of today?解决方案Anyone out there to help?
I am an armature access programmer trying my best to design my own database so your patience and detailed instructions is much appreciated.
I have birthdates in my "participants" table
1) How do I set the criteria so that I only see people that are older than xThis would be done using a query. Assuming birthdate is the field name and age restriction is 35.
Expand|Select|Wrap|Line Numbers
Make the control source of the textbox
Code:
=DateDiff (''yyyy'', Now(), [birthdate])
----------------------
Thank you
2 problems,
1) why is there a minus sign before the age?
2) it only calculates it based on the birthyear which means it isn''t always accurate (it could be up to 364 days off)
这篇关于帮助在出生日期使用日期的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取
|
15天全站免登陆