Page 1 of 1
Displaying Band Totals
Posted: 08 Nov 2015, 13:55
by Mi0GRG
Hi all,I've been using Log4OM for a few weeks now and I'm very pleased with it,it works very well with my IC 7200 and is far superior to my previous Logging Program.
I was wondering if there was a way to display my countries worked or Band Totals for a specific year,if I wanted to see my countries worked so far in 2015 on each HF Band for instance,is there a way of doing this?Any help greatly appreciated.
Thank's,Mick
Mi0GRG
Re: Displaying Band Totals
Posted: 08 Nov 2015, 16:47
by K7PT
For now, the easiest way is too filter your log by year and generate a ADIF that you can import for that year. Then select that log and it will display band/country totals for that log.
Re: Displaying Band Totals
Posted: 08 Nov 2015, 18:25
by PB4FUN
Or get a SQlite browser and paste the following query :
Code: Select all
select distinct(Country), 0.7 as band from log where (qsodate like('2015%')) and band="70cm"
union
select distinct(Country), 2 as band from log where (qsodate like('2015%')) and band="2m"
union
select distinct(Country), 6 as band from log where (qsodate like('2015%')) and band="6m"
union
select distinct(Country), 10 as band from log where (qsodate like('2015%')) and band="10m"
union
select distinct(Country), 12 as band from log where (qsodate like('2015%')) and band="12m"
union
select distinct(Country), 15 as band from log where (qsodate like('2015%')) and band="15m"
union
select distinct(Country), 17 as band from log where (qsodate like('2015%')) and band="17m"
union
select distinct(Country), 20 as band from log where (qsodate like('2015%')) and band="20m"
union
select distinct(Country), 30 as band from log where (qsodate like('2015%')) and band="30m"
union
select distinct(Country), 40 as band from log where (qsodate like('2015%')) and band="40m"
union
select distinct(Country), 80 as band from log where (qsodate like('2015%')) and band="80m"
union
select distinct(Country), 160 as band from log where (qsodate like('2015%')) and band="160m"
order by band, country
Re: Displaying Band Totals
Posted: 08 Nov 2015, 18:48
by Mi0GRG
Thanks,Meindert and Chuck for your prompt replies,I will try both suggestions and see what works best for me.
73 and again thank you.
Mick
Mi0GRG