Page 1 of 1

DXCC

Posted: Sat Oct 09, 2010 8:25 pm
by G0BLB
Hi Colin
Is it possible in DXCC to have a way of telling me the number of DXCC worked in the course of a year and during the year and how many required this would be handy for some of the club logs for the yearly DXCC and if it could be interacted with cluster this would be great .
Or should I start a new log on the start of the year.
Kind regards
Rich
G0BLB

DXCC

Posted: Sat Oct 09, 2010 8:25 pm
by G0CUZ
Hi Rich

This will not be a real possibility without - as you suggest - using individual annual logs.

For a full report like you probably require you would have to use a master log, and at end of each period, add the 'yearly' log to it.

Some limited information could be got from the log using a search query.....
Cut and paste this query to Menu.Seach.Search window

SELECT DISTINCT CODE FROM LOG WHERE DATE Between #01/01/2010# and #31/12/2010# and CODE > 0

Click on EXECUTE button.

This assumes your log is call "LOG" and this will only give a quick COUNT of number of countries worked, it will not show what Countries have been worked or what is needed.

You can adjust the dates to suit your needs.
(N.B date may need to be set as #12/31/2010# for U.S. date formats)

You could also filter this count for a particular band by adding this to the end of above query string

AND BAND BETWEEN 14 AND 15

(for 20m)





73 Colin G0CUZ
Winlog32 Author

DXCC

Posted: Sat Oct 09, 2010 8:25 pm
by G0BLB
Colin
Thank you for your help and a quick response I think I will use my trusted pen and paper and the old fashioned tick off .
Regards
Rich G0BLB