Re: how do i calculate an age using MS Access? I'm a novice.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
Date: Thu, 29 Jun 2006 12:50:41 +0800

See:
http://allenbrowne.com/func-08.html
for an explanation of what works and what does not.

If you copy the Age() function from that page, paste it into a new module,
you can add a text box to your form or report, and set its ControlSource to:
=Age([birthdate])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"mac010904" <mac010904@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8C0961B0-A725-42E5-9F3F-7989ABD1B323@xxxxxxxxxxxxxxxx

I don't know how to inter a query yet. I need to calculate age and have the
answer displayed. one column has the birthdate and other the age.

Prev by Date: Re: This one's a challenge: 1.9 not equaling 1.9..... What's going on???
Next by Date: Re: not all records being query
Previous by thread: Re: Calculating percentages
Next by thread: How to use several joins in one query?
Index(es):
- Date
- Thread

Relevant Pages

Re: Question for evolutionists - Most ducked/dodged thing by creationists?
... Now if a large number of different crystals in the same layer of rock ... all have the same age, we might conclude they were all formed about the ... compare these ages in different layers, ... Good explanation. ...
(talk.origins)
Re: A few serious Questions for the Evolutionist.
... If I were to conclude that a different theory is a better explaination of evolution than the current one, I would not be burned at the stake, tortured, expelled from my community nor would I find myself ... I'd obviously have reasons why my explanation explained the facts better ... what age I grew up but I recall saying to a friend around the age ... I gain comfort that I am now able to make my own contribution to the society we have built - that my work helps improve the world in some small way for those who will follow us, even something as trite as my taxes ensuring that these people I mentioned, now retired, will not go cold this winter nor worry about their medical care. ...
(talk.origins)
Re: Helpful NEW online pedigree linked databases
... capable of analysis of those claims and some explanation. ... other instances an age is given on a painting (even if the age was not ... that happened to be stored among the original PRO State Papers on ...
(soc.genealogy.medieval)
Re: calculating age
... Perth, Western Australia. ... Tips for Access users - http://allenbrowne.com/tips.html ... "Nancy" wrote in message ... > The problem is that I need the age in years + months ...
(microsoft.public.access.queries)
Re: file date
... > I need to get the files dates on my script. ... > following piece of code and explanation: ... > returns the age in days since someone last looked at the file. ... See perldoc -f stat. ...
(comp.lang.perl.misc)