Get a Count of Customers by Bracketed Age Demographic Group Ranges in Microsoft Access

In this Microsoft Access video tutorial, I'm going to teach you how to calculate the ages of your customers, and then display them in bracketed demographic age groups, such as "under 18," "19 to 25," "26 to 45," "46 and older," etc.
Philip from Des Moines, Iowa (a Gold Member) asks: I do a lot of work with age demographics. Right now, I copy all of my customer data over to Excel to do my reporting. I need to know, for example, how many customers are in their 30s, 40s, 50s, etc. Can this be done in Access alone?
Members will learn how to make the demographic brackets user-editable, so you don't need to make design-time changes to your query. We'll also have some fun with pie charts!
MEMBERS VIDEO:
• Age Demographics EXTEN...
UPDATE:
I will show you another method to create the age demographic group brackets using the Switch function in tomorrow's Fast Tips video here: 599cd.com/AgeD...
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
599cd.com/AgeD...
PRE-REQUISITES:
Calculate Age: 599cd.com/Age
Aggregate Query: 599cd.com/Aggr...
IIF Function: 599cd.com/IIF
RECOMMENDED COURSES:
Access Expert 27: 599cd.com/ACX27
LINKS:
Decades: 599cd.com/Decades
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Age Group Range Statistic, age demographics, demographic reports, age groups, age brackets, Group age data into age ranges, how to I make a query for age groups, Age Group, grouping
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@stanTrX]

Brilliant! 👍

[@599CD]

Glad you liked it!

[@ask_puranik]

Super sir, First comment

[@599CD]

People still do the whole "first comment" thing, huh?

[@mustaphati]

Hi sir I would know if we can program posts on Facebook or insta directly via ms.access??

[@599CD]

Never tried. I hate Facebook, so you're on your own with that one.

[@mustaphati]

@@599CD i nerver saw it before and unfortunately almost applications who did that are not free, so i am thinking about it, it will be very interesting thing to do it with ms.access and it is necessary to have a good Management with all socials medias that we have today Please tell me if you have a channel who exposed that

[@mathmagics8212]

Oooooo thanks alot sir It also answerred my more than two old years question on internet I have list obt marks and their grade accorrding to obt marks What i want to do find no of stdnts in each grade from lis to calculate its g.p.a

[@599CD]

Cool

[@vitom5513]

I've used this formula for age for a few years. I don't remember how I figured it out, it's been a while: =DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")

[@599CD]

Yeah... that's a head scratcher

[@fgalviarlab382]

hi sir.. did i get it right? advance happy birthday in two wks!! happy to know we were born same year!! just want to ask why this is not working in my query if you don't mind... 5AM-6AM: IIf(TIME=6:00 AM,1,0)... it doesn't seem to recognize the time... thanks of any help!

[@599CD]

Thanks. Times have to be in # signs.