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
Displaying Band Totals
Re: Displaying Band Totals
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.
K7PT-Chuck "#1 Top of the Honor Roll"
Re: Displaying Band Totals
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
PB4FUN Meindert; Rig : Icom IC-9100 / Ant: Falcon OUT-250-B @4m AGL; 144 MHz 16 el @ 4m AGL; 70 cm 23 el @ 5 m AGL
Re: Displaying Band Totals
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
73 and again thank you.
Mick
Mi0GRG