04-10-2015, 11:52 AM,
|
|
DG7RO
Junior Member
|
Posts: 48
Threads: 16
Joined: Jun 2013
Reputation:
0
|
|
WPX-missing QSL Logbook view?
Hi,
I need a logbok view (not a pivot-table or statistic) where I can select QSOs for a WPX endorsement:
Select all QSOs for each prefix/WPX where I did not sent a QSl card and the WPX is not confirmed with eqsl or card for each band! (Mode does not matter)
any clue?
Torsten, dg7ro
|
|
10-10-2015, 04:49 PM,
|
|
DG7RO
Junior Member
|
Posts: 48
Threads: 16
Joined: Jun 2013
Reputation:
0
|
|
RE: WPX-missing QSL Logbook view?
This worked.
SELECT QSO.P_WPX AS WPX,
QSO.[Band] AS [Band],
FIRST(QSO.L_Call) AS Rufzeichen,
FIRST(QSO.L_QSL_SEND) AS QSLs,
FIRST(QSO.L_QSL_RECEIVED) AS QSLr,
FIRST(QSO.L_QSL_ACTION) AS [QSL-Aktion],
FIRST(QSO.L_eQSL_RECEIVED) AS eQSLrx,
FIRST(QSO.L_QSOSeqNR) AS QSOSeqNr
FROM QSO
GROUP BY QSO.P_WPX,
QSO.[Band]
HAVING (((FIRST(QSO.L_QSL_SEND) = 0)
AND (FIRST(QSO.L_QSL_RECEIVED) = 0)
AND (FIRST(QSO.L_eQSL_RECEIVED) = 0)))
ORDER BY QSO.P_WPX ASC,
QSO.[Band] ASC
|
|
10-10-2015, 07:10 PM,
|
|
DG7RO
Junior Member
|
Posts: 48
Threads: 16
Joined: Jun 2013
Reputation:
0
|
|
RE: WPX-missing QSL Logbook view?
aehmm..... small problem:
in my log i have something like this:
jw9jka 17m@date1 - no qsl send or received
jw9jka 17m@date2-later - qsl send and received
Now my select statement selects the first qso of 17m as this is not confirmed and no qsl is sent.
But later I got a QSL card and the prefix JW9 is confirmed.
How could this be included in the selection-generator
Torsten
|
|
15-10-2015, 08:36 AM,
|
|
DG7RO
Junior Member
|
Posts: 48
Threads: 16
Joined: Jun 2013
Reputation:
0
|
|
RE: WPX-missing QSL Logbook view?
will try next time at home.
btw: the cq award manager accepts eqsl submitted via eqsl.cc and paper without paying.
LOTW must be paid to the ARRL then this QSLs are also available for WPX but not for free...
|
|
|