how to sort by number of times played, and last played?

  • Thread starter Thread starter Merlin Zener
  • Start date Start date
M

Merlin Zener

Hi,

I've been keeping track of the songs played by my band for the
last few weeks, and I want to be able to sort the list by how
often the song has been played, and also by when it was played
last. Currently I have column headings of:
[date] [set number] [song number (within the set)] [song name]

and I would like to get a list [or report, whatever] like this:
[song name] [times played]
song 1      26
song 2      24
song 3      20
song 4      20
song 5      16
etc

and also:
[song name] [last played]
song 1      [date][set][no.]
song 2      [date][set][no.]
song 3      [date][set][no.]
song 4      [date][set][no.]
song 5      [date][set][no.]
etc [in order of last played]

Can anyone give me any tips about how to begin? Some kind of query
function? Or is there some kind of software already written for
this kind of thing? [I'm thinking, there must be, for all those
"top ten" charts etc.]


Thanks in advance for any advice:)
 
Back
Top