Ms Access: How to extract Age Group Range Statistic

  Рет қаралды 2,371

𝐊𝐚𝐦𝐚𝐲𝐨 𝐀𝐤𝐨🌈™

𝐊𝐚𝐦𝐚𝐲𝐨 𝐀𝐤𝐨🌈™

Күн бұрын

Пікірлер: 11
@Sarahbalios
@Sarahbalios 4 жыл бұрын
ayayy wa jud mahina tlga ako sa ganito kaya fullwatched lang ako dito kahit d ko gets hehehe
@Nurjima
@Nurjima 4 жыл бұрын
Wow very useful galing nmn
@Jennyschannel
@Jennyschannel 4 жыл бұрын
Ang galing mo sa computer sir... Dagdag kaalaman.
@sumirekawaii37
@sumirekawaii37 4 жыл бұрын
Omg amazing medyo nagets ko ngayon tong vlog mo lodi..
@KamayoAko
@KamayoAko 4 жыл бұрын
thank you for visiting...
@MiracleMARILAGdelaCruz
@MiracleMARILAGdelaCruz 4 жыл бұрын
Very useful - tnx for the techniques
@thewolfofbitcoin6175
@thewolfofbitcoin6175 4 жыл бұрын
nice!!!
@tutsecret499
@tutsecret499 3 жыл бұрын
Thank you. But I also I need to display the column Age and keep visible besides the Age group column. I know how to display the Age colunm but how to add the Age Group, next to Age column.
@KamayoAko
@KamayoAko 3 жыл бұрын
Yes, you are right add new module and copy paste below code and call this code in your query field along with BirthDate.... Public Function AgeGroup(dtmBirthDate As Date) As String Dim intAge As Integer 'Age Calculation intAge = DateDiff("yyyy", [dtmBirthDate], Now()) + _ Int(Format(Now(), "mmdd") < Format([dtmBirthDate], "mmdd")) 'ORIG 'Int(Format(Now(), "mmdd") > Format([dtmBirthDate], "mmdd")) 'intAge = DateDiff("yyyy", dtmBirthDate, Now) ' If Date < DateSerial(Year(Now), Month(dtmBirthDate), _ ' Day(dtmBirthDate)) Then Select Case intAge 'For each Age range, write out Age Group (used in qry) Case 0 To 5 AgeGroup = "1. Children 0 - 5 years old" Case 6 To 12 AgeGroup = "2. Children 6 - 12 years old" Case 13 To 17 AgeGroup = "3. Children 13 - 17 years old" Case 18 To 35 AgeGroup = "4. Children 18 - 35 years old" Case 36 To 50 AgeGroup = "5. Adult 36 - 50 years old" Case 51 To 65 AgeGroup = "6. Adult 51- 65 years old" Case Is >= 66 AgeGroup = "7. Adult 66 years old & Above" End Select End Function
Microsoft Access VBA # 1 | How to enable and disable field
7:33
𝐊𝐚𝐦𝐚𝐲𝐨 𝐀𝐤𝐨🌈™
Рет қаралды 4,3 М.
Friends make memories together part 2  | Trà Đặng #short #bestfriend #bff #tiktok
00:18
Fake watermelon by Secret Vlog
00:16
Secret Vlog
Рет қаралды 33 МЛН
Random Emoji Beatbox Challenge #beatbox #tiktok
00:47
BeatboxJCOP
Рет қаралды 16 МЛН
How to use Microsoft Access - Beginner Tutorial
31:07
Kevin Stratvert
Рет қаралды 3,2 МЛН
Age Demographics in Microsoft Access Using the Switch Function - TechHelp Addendum
10:46
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
How I'd Learn Data Analytics in 2024 (If I Had to Start Over)
14:08
CareerFoundry
Рет қаралды 812 М.
АНГЛИЙСКИЙ НА СЛУХ - Tom Hardy (Том Харди)
42:41
ВОТ ЭТО английский
Рет қаралды 19 М.
Creating a Switchboard Menu in Microsoft Access
13:04
Andrew Comeau
Рет қаралды 10 М.
Friends make memories together part 2  | Trà Đặng #short #bestfriend #bff #tiktok
00:18