Marathon Scoring
Posted: Mon 16. Nov 2015, 16:35
I am trying to keep track of my CQ Marathon score as the year progresses but haven't figured out how to get the total Zones worked for the year.
Any hints?
Any hints?
RUMsoft, software for HAM radio on the Mac.
https://www.dl2rum.de/forum/
Code: Select all
select distinct cq from logbook where datetime >= '2015-01-01' order by cast(cq as integer)
Code: Select all
select cq,callsign from logbook where datetime >= '2015-01-01' group by cast(cq as integer)