Age Next year

A

Amin

Hi all
Table = ChildEnroll field = Child_Date_Of _Birth
How do I create a query or report showing how many children will turn 6 year
old next 12 months
Thanks
Amin
 
J

Jeff Boyce

Amin

I seem to recall an "Age" calculation routine, probably at mvps.org/access.
Or you could try doing an on-line search...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

John W. Vinson

Hi all
Table = ChildEnroll field = Child_Date_Of _Birth
How do I create a query or report showing how many children will turn 6 year
old next 12 months
Thanks
Amin
Click to expand...

SELECT <whatever fields you want to see>
FROM ChildEnroll
WHERE DateAdd("yyyy", 6, [Child_Date_Of_Birth]) BETWEEN Date() AND
DateAdd("m", 12, Date())

John W. Vinson [MVP]
 
A

Amin

Thank you John

John W. Vinson said:
Hi all
Table = ChildEnroll field = Child_Date_Of _Birth
How do I create a query or report showing how many children will turn 6 year
old next 12 months
Thanks
Amin
Click to expand...

SELECT <whatever fields you want to see>
FROM ChildEnroll
WHERE DateAdd("yyyy", 6, [Child_Date_Of_Birth]) BETWEEN Date() AND
DateAdd("m", 12, Date())

John W. Vinson [MVP]
Click to expand...
 
Top