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

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.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Mariesanfran" <(E-Mail Removed)> wrote in message
news:9D7ADDDA-95F8-407B-AA36-(E-Mail Removed)...
> 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

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:(E-Mail Removed)
web:http://obm.itnews.googlepages.com

ˮˮˮˮˮˮˮˮˮˮˮˮˮˮˮÂäʯ³ö
"Mariesanfran" <(E-Mail Removed)> дÈëÓʼþ
news:9D7ADDDA-95F8-407B-AA36-(E-Mail Removed)...
> 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