Hi Keith,<BR><BR>I did something like this a few weeks ago, but can't find it now. It is a fairly complicated statement that you put in a query. I originally found it by just googling something like "access database convert date of birth to age" and found the answer almost straight away. I'm sorry I haven't still got it.<BR><BR>Lesley<BR><BR>> Hi all you Access Experts.<BR>> Three of us have a problem - how do we get Access to tell us which age<BR>> group an individual belongs to (Junior 10-12, Intermediate 13-14, Senior<BR>> 14-18) starting with date of birth (an entered field in the members<BR>> table). We worked out how to create a query that would get current age<BR>> based on date-now and dob, then selection based on a particular age<BR>> range for criteria, but that simply gives me a list of member names who<BR>> fall into<BR>> that age group at any time. What I want to do is flow that information<BR>> into something that will flow into a report, without having to manually<BR>> look through the lists of names of members in a particular age group.<BR>> Hope that isn't too complicated!<BR>> Regards, Keith (for Keith, Henry & Diane)<BR>> Keith Richardson<BR>> <BR>> _______________________________________________<BR>> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe<BR>> IT Applications Mailing List kindly supported by<BR>> http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and<BR>> http://www.vitta.org.au - VITTA Victorian Information Technology Teachers Association Inc<BR><BR><BR>___________________________________________________________<BR>Ms Lesley Humphries<BR>Learning Technologies Co-ordinator<BR>Santa Maria College<BR>50 Separation Street<BR>Northcote 3070<BR>Ph: 9489 7644<BR>___________________________________________________________<BR>
This email and any attachments may be confidential. You must not disclose or use the information in this email if you are not the intended recipient.
If you have received this email in error, please notify us immediately and delete the email and all copies.
The College does not guarantee that this email is virus or error free.
The attached files are provided and may only be used on the basis that the user assumes all responsibility for any loss,
damage or consequence resulting directly or indirectly from the use of the attached files, whether caused by the negligence of the sender or not.
The content and opinions in this email are not necessarily those of the College