Two options:
In query design, go to the AGE field...in the criteria cell, copy and paste one of the following:
Between 16 And 25
OR if you want a prompt to select an age range, use
Between [Enter First Age] And [Enter Last Age]
The first option always give you only 16 thru 25. The second option allows you to input any range you want.
pc
Hassan <[EMAIL PROTECTED]> wrote:
Hello All,
I have designed a membership database with various functions.
Currently I am working with reports in which I ran across an issue
that requires expert advice.
I have members of all ages in my database, and I need to categorize
the ones in the age range of 16-25 years. How can I single out only
the members within this age criteria so there name will show up in my
report??
I want my report to show only the members in the age category 16-25,
so how exactly do I restrict the report to do that?
Thanks alot
here is the link to my database here so you guys can look at it and
tell me how to proceed. please try to understand i am new at this and
trying very hard to learn it.
thanks alot
http://www.megaupload.com/?d=RMG98PV9
SPONSORED LINKS
Microsoft access developer Microsoft access help Microsoft access database Microsoft access training Microsoft access training course Microsoft access programming
Yahoo! DSL Something to write home about. Just $16.99/mo. or less
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
