[RTTY] RTTY via LoTW - WHO HAS WHAT?

[k0bx at arrl.net]

Hi Dick, I was wondering the same thing.

But what I do takes a bit of programming.  I use
DXBASE for my station log.  After uploading from
DXBASE to LOTW then I can download the LOTW confirmed
file into DXBASE.  So all my confirmed LOTW Q's showup
in DXBASE.  I then wrote the below QUERY which said:

Give the prefix of the DXCC country only once, 
where the Mode is RTTY
and the LOTW confimed date is populated
and it is not a deleted country.

This is how I came up with my total of 169.  When I
was checking to make sure my total was correct, I made
a report giving me all the stations with date/time
that was rtty and LOTW.  This way I was able to check
the validity of my count.

It only took 25 years in Information Systems to come
up with this!!

Joe K0BX

SELECT DISTINCT [QSO-TAB].[QSO-PREFIX]
FROM [QSO-TAB] INNER JOIN [PREFIX-Pri] ON
[QSO-TAB].[QSO-PREFIX] = [PREFIX-Pri].PREFIX
WHERE ((([QSO-TAB].[QSO-MODE])="5") AND
(([QSO-TAB].[QSO-LOTWREC])>="") AND
(([PREFIX-Pri].[DEL-STATUS])=0));



--- Dick Kriss <aa5vu at sbcglobal.net> wrote:

> How do you check your RTTY status on LoTW?   I
> pulled up may LoTW account
> and was able to find my DXCC credits for RTTY but
> cannot seem to find how
> many are confirmed by LoTW vs QSL cards.
> 
> Where do you get the numbers used for the LoTW
> update?
> 
> Dick AA5VU