Displaying Band Totals

[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

[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.

[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

[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