design

[sadie]

have access 2000
I have a table containing kid ages in years (8,9,10,etc)
How can I make a report and when I want to report on the ages have something like " of kids between 8 and 10 year old etc

 

[SharonC]

Does your table have the actual ages of the children or their date of births?

If you just have their ages, you could do a query on the age field using the Between function.

Just a thought

 

[sadie]

it has the actual age
Can I do a "between" in reports

 

[Rich]

Do you want to list all the ages and goup on certain defined groups, or select only certain ages for one group

 

[sadie]

I want to be able to coun how many kids are between 8 and 10, and how many are between 11 and 13 etc

 

[SharonC]

No, you can't use "between" in reports (from what I can tell) but you can create a Select Query using all the fields you'd like to have on the report and in the criteria box for Age type:

Between 8 and 10.

Then develop your report based on that query.

Hope this helps

 

[Rich]

Look up the Where condition of the open report method

 

[Pat Hartman]

You can create an artificial grouping in the query used as the report's recordsource.

Select IIf(ChildAge >= 8 And ChildAge <=10, "Age 08-10", IIf(ChildAge >= 11 and ChildAge <= 13, "Age 11-13", "Age Other")) As AgeGroup, ....

Then in the report, group on AgeGroup.