PC Review


Reply
Thread Tools Rate Thread

From Date of Birth Select records inbetween ages

 
 
Mariesanfran
Guest
Posts: n/a
 
      31st Jul 2008
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
 
Reply With Quote
 
 
 
 
Sylvain Lafontaine
Guest
Posts: n/a
 
      1st Aug 2008
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



 
Reply With Quote
 
Asad Ali
Guest
Posts: n/a
 
      2nd Aug 2008
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



 
Reply With Quote
 
logo
Guest
Posts: n/a
 
      13th Oct 2008
ˮˮˮˮˮˮˮˮˮˮˮˮˮˮˮÂäʯ³ö
"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



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
working out ages from date of birth =?Utf-8?B?QmVsaW5kYQ==?= Microsoft Excel Worksheet Functions 1 17th Feb 2006 02:59 PM
How do I calculate ages in excel using date of birth & another dat =?Utf-8?B?UGFuaWFj?= Microsoft Excel Misc 4 18th Oct 2005 04:25 AM
dates of birth and ages fields =?Utf-8?B?YW1tZWc=?= Microsoft Access 1 24th Jun 2005 02:27 PM
ages/date of birth =?Utf-8?B?aXJpc2hjaGljazI4?= Microsoft Excel Worksheet Functions 1 21st Mar 2005 09:22 PM
Dates of Birth and ages =?Utf-8?B?UGF1bGx5IEM=?= Microsoft Excel Misc 3 28th Jan 2004 10:31 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:12 AM.