report

[sadie]

I have to do an annual report on my cases
I have a field [county]
another field [age]
etc

How can I have these calculations come right into the report
For example there are 60 cases to calculate the 2 counties the kids come from or their ages

Thanks

 

[GumbyD]

sadie -

I read your post, but I am not sure what the issue is. What data do you have (ie Birthdate? country?)? What do you need to display (for example I need to group up my cases by county and then by age with my age groups being 0-6, 7-11, 12-18 etc). Have you created a query to base the report off of or are you using a table for your record source?

GumbyD

 

[sadie]

Thanks
I need to group like
how many between the ages of 6-10m, 11 -14,15-18
also, how many from Nassau County, Suffolk County etc.

I'm not sure if I should do it off a query

 

[GumbyD]

Sadie -

Is this two separate reports on just one? It sounds like two. Anyway if you have an age field (which by the way is a bad idea because anytime anyone has a birthday you have to go in an change the data - if you store birthdate you can calculate age using a datediff function) back to the age field be it stored or calculated. On your report you can go to sorting and grouping and select to GroupBy a given field. On the bottom of the form you can choose to have a group header, footer, both or neither - in your case I would recommend a header so you can show which age the data relates to. Also on this form you can select an interval. This may work for you as long as you have people in all of the age groups (if your age group was 6-10 you would need to have at least one 6 year old, one 7 year old, one 8 year old, one nine year old, and one 10 year old) and the intervals need to be consistent (always 4 years or always 5 years). If that is not the case then you will need an expression in your query that will sort out the people for you. Something like the following should work:

AgeGroup: (IIf([age]<6,1,IIf([age]<11,2,IIf([age]<15,3,IIf([Age]<19,4,5)))))

That will return a 1, 2, 3, 4, or 5 depending on which age group they fall into. Once you have that you can group on the AgeGroup field.

Good Luck

GumbyD

 

[GumbyD]

One last thing - once you have the grouping levels in place then in grouping level footer you can count the number of people in a text box. To count the people in a group use =Count([ID]). Where the ID field referred to in the expression is a unique identifer for each person.

GumbyD