Use a Query (from the Query Design window) and put all of the fields you want in your report in the query. In the "Age" field's criteria cell, put the following: "Between 16 And 25". Then base your report on the query. If you decide later that you want to prompt the user for the age of the members to be printed, you can do that simply by changing the criteria to have a question in square brackets "[]" Whatever is typed in the square brackets will be a prompt for the user.
Since you said you are new to access, I would suggest that you create the base for the query (with all of the fields) using the QUERY WIZARD. After you save the query that the wizard creates for you, you can go into it in DESIGN VIEW and add the criteria. HTH! Alienwebmaster ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income homes are not online. Make a difference this holiday season! http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> 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/
