10-10-2015, 04:49 PM,
|
|
DG7RO
Member
|
Posts: 51
Threads: 17
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
Member
|
Posts: 51
Threads: 17
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
Member
|
Posts: 51
Threads: 17
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...
|
|
|