Segregating Information

[KantFigureItOut]

I have a report that has the following information:

Age on August 1st,2006, then it list the age

15 Childs name phone number etc.
John Doe 999-9999
fhsdfasfj
Jane Doe 888-8888
jkflajsdkl

14 Childs name phone number etc.
Sarah Jones 777-7777
jfkasldjd
Tommy Art 666-6666 none

What I am wanting to do is have a report that just pulls out, say, just the
15 year olds. My report currently has all the ages from 5 years old to last
age of 16 years old. Can anyone help me with that? Thanks in advance.

 

[Guest]

If you wanted to fix the Report to only and always show only age 15 values -
you could set it up using the WHERE command on open.

Or if the Report is based on a Query - you could run the Query to return
only age 15 values....and then the Report would only show the results of the
Query.

But if you want to change this on-the-fly and pick the age that the report
shows. Then you really need to preceed the Report with a Form where you
specify the Age to Report and have this value flow thru to the criteria of
the Query or Filter the Report..... Or preceed the Report by running a
Parameter Query that prompts you for the age wanted in the report....