Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
WPX-missing QSL Logbook view?
10-10-2015, 04:49 PM,
#3
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
Reply


Messages In This Thread
WPX-missing QSL Logbook view? - by DG7RO - 04-10-2015, 11:52 AM
RE: WPX-missing QSL Logbook view? - by EA3GCV - 05-10-2015, 12:10 AM
RE: WPX-missing QSL Logbook view? - by DG7RO - 10-10-2015, 04:49 PM
RE: WPX-missing QSL Logbook view? - by DG7RO - 10-10-2015, 07:10 PM
RE: WPX-missing QSL Logbook view? - by EA3GCV - 14-10-2015, 08:20 AM
RE: WPX-missing QSL Logbook view? - by DG7RO - 14-10-2015, 06:17 PM
RE: WPX-missing QSL Logbook view? - by EA3GCV - 14-10-2015, 11:18 PM
RE: WPX-missing QSL Logbook view? - by DG7RO - 15-10-2015, 08:36 AM
RE: WPX-missing QSL Logbook view? - by EA3GCV - 15-10-2015, 01:15 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)