Grouping Data Into Sections from A Field?

[MarkF2004]

Hi there



[Caveat: I am new-ish to Access 2010, I have zero VBA knowledge but I am willing to try stuff out if I can get help! I am tasked with sorting out a database and progress (so far) is fairly good. I would appreciate any help or pointers that you might provide.]

I have a database with a list of clients. One field is for their date of birth.

I have to report on equality and need to advise how many clients we have within the following age groups:

16 - 24
25 - 34
35 - 44
45 - 54
55 - 64
65+

I have looked through the group and sort functions and cannot see anything obvious to help me there. Can anyone get me started at all?

Thank you.

MarkF

[ranman256]

You need to change the query, make a virutal field with a home grown function.
In vbe, INSERT, MODULE,
then paste this code.
Save

In the query, in a new column, AgeGrp([age]) (if you have a field called age, or calculate age in it: datediff("y",date1,date())

Public Function AgeGrp(byval pvAge)
   If pvAge >= 16 And pvAge <= 24 Then
       AgeGrp = "16 - 24"
   ElseIf pvAge >= 25 And pvAge <= 34 Then
       AgeGrp = "25 - 34"
   ElseIf pvAge >= 35 And pvAge <= 44 Then
       AgeGrp = "25 - 34"
   ElseIf pvAge >= 45 And pvAge <= 54 Then
       AgeGrp = "25 - 34"
   ElseIf pvAge >= 55 And pvAge <= 64 Then
      AgeGrp = "25 - 34"
   ElseIf pvAge > 64 Then AgeGrp = "65+"
End Function

[MarkF2004]

Hello there ranman256

Thank you for that. I will get to work on it and report progress...

Regards