I have a Filemaker database I've designed that is used for idea/suggestion submission for the company I work for. There are all sort of statistics that are generated using ExecuteSQL commands, but I can't figure this one out...
Background -- I have a free text field called "Name" where the user inputs their Name. I need a report/calculation to somehow generate a list of the unique names and count how many ideas they have submitted.
Is there a way this could be done?
Please let me know if any additional information would be helpful. I've been self taught Filemaker and this forum has been really helpful during the development of my database.