AnsweredAssumed Answered

How to show the Total count of birthdays by Year?

Question asked by king_arthur on Nov 8, 2017
Latest reply on Nov 16, 2017 by fmpdude

So i know that my question is in the area of Summaries and calculation fields, i just cant wrap my head around it.

 

Now i am working on a very simple project - it has One Table - Users

fields:

First_Name

Last_Name

Birthdate

c_year     Calculation = Year(Birthdate)

summary_year     Summary Field - Count Of c_year

 

I want to display either in a portal or on a layout, or create a script to do it...

The Year         Total Number of Birthdays in that year.

 

1988                34 "Birthdays"

 

It seems so simple and while i am still learning the ropes on filemaker, I seem to get the harder questions better than one like this that just seems to stare me in the face but I just can't get.

Outcomes