How do I convert an age and gender to category

[Troyle]

I am a beginner with Access and I am learning by trying to write an application for our running club. What I can't figure out, is how to show a person's category on a report. As an example, a female runner who is 43 years old would be an F40, a male runner who is 56 years old would be a M55.<br>I can generate the reports that show the different groups in a race, but I would like to be able to show a category such as F45 or M60 on a listing of members. Any clues would be highly appreciated.<br><br>Thanks<br>Tony

 

[kathryn]

In report design view, look at sorting and grouping, under teh View menu.&nbsp;&nbsp;Group on your runners age and then Sex, or Sex then Age, if you want all females before males.<br><br>Click on the Age group line and in the bottom half of the Sorting and Grouping box, change GroupOn to Interval and change GroupInterval to 5.<br><br>Then in the report design, create a header field in the inner of the two groupings which is the combination of Sex and Age.&nbsp;&nbsp;<br><br>This is hard to explain in words.&nbsp;&nbsp;Why don't you try what I have written and then post again with any problems?&nbsp;&nbsp;Good luck.<br> <p>Kathryn<br><a href=mailto: > </a><br><a href= > </a><br>