From Date of Birth Select records inbetween ages

[Mariesanfran]

Hi

I have a childcare registration form to show Firstname, Lastname, Date of
Birth,Age

Age is not in a table it is a calculated field.

I then have a button that opens a report (which is based on Quey) to show
child records.

My problem is I only want to show specific ages. I need to only show
records for children between the ages of 8 weeks to 4 years.

I managed to figure out how to calculate age fine, but I am totally stuck on
how to bring up the records for just this age group.

Can anyone help? I hope I have given the correct info, I am relatively new
to access and this is my first time posting on the communities.

THANK YOU

 

[Sylvain Lafontaine]

You should add a WHERE statement that will filter the records to retrieve
only those between the age of 8 weeks and 4 years. By providing more details
on the query that you already have, this should be easy to extend.

You should also give details about what you know about Access. For exemple,
does the WHERE statement familiar to you?

Finally, you're not exactly at the right place to ask this question. This
question is about ADP and SQL-Server and there are many differences between
an ADP project and a MDF or ACCDB file and also between the sql language
used with Access from the one used on SQL-Server. You should ask this
question in a newsgroup such as microsoft.public.access.queries or
m.p.access.reports.

 

[Asad Ali]

Hi to all Group Member

yesterday I was searching from google som vedios
I hve just found a lagrest and greatest group of
online vedios on internet

which Is on daily bases
it updates vedios on daily bases
so must check it to keep intouch with the world to examine what is happing
in side our world

the link is
http://obm.itnews.googlepages.com

regards and thnanks

Asad ali
manager :E-Idea google Group
cell:+923217507176
Email:[email protected]
web:http://obm.itnews.googlepages.com

 

[logo]

ˮˮˮˮˮˮˮˮˮˮˮˮˮˮˮÂäʯ³ö