I've got a site for my local Running Club. All members have a DOB field and a Gender field and I've made a few lists that enable me to sort and filter on these.

When running races, results are categorised according to the Gender and Age group of the runner.

The Age groups will be something like:

Senior Men - 16 to 29
V30 - 30 to 39
V40 - 40 to 49
V50 - 50 to 60

Senior Women - 16 to 29
VF30 - 30 to 39
VF40 - 40 to 49
VF50 - 50 to 60

I know that the age can be calculated using CB and some of the functions posted on these forums, but I want to be able to group and list my Runners into the category age groups so that I know how many I've got in each group.

Has anyone any ideas how to do this either within Community builder lists (or if this is not possible just using MySql queries). I'm OK at messing about in phpMyAdmin if required.

Cheers,

Simon