Samjsmith Posted May 5, 2005 Share Posted May 5, 2005 I have created a database for church to track songs sung by the congregation each week. I create the worship service order in this database. The songs sung each week are entered into a "lineitem" table. I want to view in a portal and a report, songs sung the least, frequent and the most. Please note that there is no fixed number of how many times a song sung equals the least, frequent or the most, since the songs will accumulate over the years. I am using Filemaker 7. Do you have any suggestions I might go about this? Link to comment Share on other sites More sharing options...
Robert Schaub Posted May 5, 2005 Share Posted May 5, 2005 For amount of times use SongCount = calc = Count(TableName,SongName) For a report create a subsummarry layout sorted SongCount Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Archived
This topic is now archived and is closed to further replies.