There are many ways to "skin a cat" in Access. One way would be to define your criteria in vba when you open the report like so... DoCmd.OpenReport "MyReport", acViewPreview, , "Age BETWEEN 16AND 25"
Hassan <[EMAIL PROTECTED]> wrote: Hello All, I have designed a membership database with various functions. Currently Ii 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?? Thanks alot here is the link to my database http://www.megaupload.com/?d=RMG98PV9 SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software --------------------------------- YAHOO! GROUPS LINKS Visit your group "ms_access" 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. --------------------------------- May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Yahoo! Shopping Find Great Deals on Holiday Gifts at Yahoo! Shopping [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> 1.2 million kids a year are victims of human trafficking. Stop slavery. http://us.click.yahoo.com/.QUssC/izNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
