AnsweredAssumed Answered

List of summary of people start working in company

Question asked by sam0723 on Jun 18, 2018
Latest reply on Jun 21, 2018 by sam0723


HI, i am new to filemaker, i would like to ask how to show a list of  sub-summary in a field.

For example,

 

2018/4 ..............4 people

2018/3...............3 people

2018/2...............0 people

........

2017/4...............1 people

 

i am trying to use SQL to generate result but only ? shows as the result.

 

i have a date for each employee, so how to count the number for specific month if subsummary report is not allowed to use.

 

I am using Filemaker 16. Thank you

Outcomes