Showing an Age in a form - Microsoft Access Forum


	Back to Access Forum Comments List

Showing an Age in a form

Peter Yates

21 months ago

Your Tech Help video was great about calculating "Age" from "Date of Birth", via a Query, but you didn't go on to explain (how difficult it is) to get the "Age" into a form, such as your CustomerF. I only managed it by creating a sub-form, and to be fair Access let me configure it so it looks much like a normal field rather than a sub-form. I have a database involving old people who get a meals-on-wheels service and want to know their age but also do something special on their birthdays. My question I suppose is for your terrific advice on the best ways of doing all these things?

	Adam Schwanz @Reply 21 months ago
All you need to do is make a query bring in the table you're using and do the age calculation. Base the form on that query, and the age will be available.

	Peter Yates OP @Reply 21 months ago
Thanks Adam but normally users would want the age (say of an Adult Club member) in the Customer form where all their other data, address, email, phone number etc, comes from a customer or some other table. It's then not so simple to add the age from the Query.

	Kevin Robertson @Reply 21 months ago
Build your query with the fields from the Customer Table (use the * to bring in all the fields) and add the Age calculated field. Save the Query and make the Record Source of the Form whatever you saved the Query as. Then add the fields as normal from the Field List. Age will be available along with all the other fields from the Customer Table that were added to the Query.

	John Davy @Reply 21 months ago
Hi Peter, It is really quite simple. Follow Kevin's advice. Also watch Richard's video https://599cd.com/blog/display-article.asp?ID=1418 John

	John Davy @Reply 21 months ago
Hi Peter, Richard also has an extended cut video that shows another formula that is 100% accurate in calculating age. If you put that formula in a query that will populate a textbox or field with the correct age based on the date of birth. HTH John

Peter Yates OP @Reply

21 months ago

Thanks to everyone for your help. As an 81 year old but a bit of a Access novice, I still expect Access to be easier, even though I know that it's really powerful and complex. Like everything though, as knowledge and understanding of Access grows, things make more sense and what seemed difficult starts to seem easier and more logical. The Forum, as well as Richard's expertise helps though. For me. learning Access and hopefully VBA, as brain exercise, it's a bit like learning French, you start with a few words but getting fluent takes a lot of work. Thanks again guys.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen