Report people grouped to years

[gerhard_s]

Hi,

I have a table containing names and dates of birth.

Now I want to create a report that gets as input a sports season selected by the user (which defines deadlines for age groups).

Based on the entered season, the output list should look like:

In 2010/11 members are in following categories
===================================

U18 (01.01.1993 to 31.12.1995)


-------------------------------
Sabrina 12.02.1993
Tom 15.02.1994

U15 (01.01.1996 to 31.12.1997)
-------------------------------
Sam 02.03.1996

U13 (01.01.1998 to 31.12.1999)
-------------------------------

and so on...

What is the best way to do this?
One report with a sub report for each category and each subreport running a query? Or is there something more simple?
Can a report pass a parameter to a query (i.e. for searching the people of various age groups)?

Thanks for your help!

[RuralGuy]

Ask your question of the user in a form, which can pass this information on to a query. A report is just basically a piece of paper.

[weekend00]

one report with group by age groups can do it. The key is to decide the group.

Create a table grouptable:
grp fromAge toAge
U19 19 99
U18 16 18
U15 14 15
U13 12 13
U11 0 11

In your form "MyForm", put season in a combo box "cb_season" cb_season showing "10/11","09/10" but values is 2011, 2010 ( you may type in values or create a table for these)

use following query as data source of the report:

SELECT grouptable.Grp, MemberTable.MemName, MemberTable.birthday
FROM MemberTable, grouptable
WHERE ((([forms]![myform]![season]-Year([birthday])) Between [fromage] And [toage]));

In the report, create group by Grp.

[gerhard_s]

Hello weekend00,

thanks for your support! With your hints and some experiments I got it solved and it works fine now!

Br,
Gerhard