Hi there.
Let me start by saying I'm very very new to Acess and coding-language and terms, so I am prone to asking stupid questions and require clarifications, mainly because I want to learn.
I'm setting up a resume database for my employer and they have asked me to calculate applicants actual ages rather than their date of birth. I've tried getting it to work with calculation field that draws on today's date and their date of birth, but today's date doesn't update. I've dabbled with an afterUpdate event to update the current date, to no avail.
Now, from browsing this forum, I can see that the best way to do this calculation is in a query, but I have had no luck actually getting this to work with the different codes suggested (DateDiff with Int, Date() and Now() ). I wish I could clarify exactly what the issue is, but I have no idea at all.
Any suggestions for an Access Dummy?
Let me start by saying I'm very very new to Acess and coding-language and terms, so I am prone to asking stupid questions and require clarifications, mainly because I want to learn.
I'm setting up a resume database for my employer and they have asked me to calculate applicants actual ages rather than their date of birth. I've tried getting it to work with calculation field that draws on today's date and their date of birth, but today's date doesn't update. I've dabbled with an afterUpdate event to update the current date, to no avail.
Now, from browsing this forum, I can see that the best way to do this calculation is in a query, but I have had no luck actually getting this to work with the different codes suggested (DateDiff with Int, Date() and Now() ). I wish I could clarify exactly what the issue is, but I have no idea at all.
Any suggestions for an Access Dummy?