Age Next year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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]
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform from query shows all records not just related records 1
Calculate age in total months only 5
Report-not required to print if field is null-concatenated field q 1
Group by month 2
Specific Age Query for a Date Range 3
Calculate an "Age Group" from age in years 10
Access Counting records based on multiple age bracket and output to tabulated report 0
change result of field based on another field 10

Back
Top