Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Songs Database


Recommended Posts

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

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


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

Terms of Use