WAE yearly stats

[EA3GCV]

Hello Torsten,

P_WAE is a field from the PQTH table and you are adding a filter in another table (LOGBOOK). You have to join first PQTH and Logbook tables. Edit the WCA statistic and see the example. In WCA:

SELECT Logbook.L_DATE,
PQTH.P_DXCC
FROM Logbook
INNER JOIN PQTH
ON Logbook.L_CALLID = PQTH.P_CALLID
WHERE (((Logbook.L_DATE >= #01/01/1995#)
AND (PQTH.P_DXCC <> '%')))

In your statistic, select WAE instead of DXCC field and set the same filters so that the final SQL is like this:

SELECT Logbook.L_DATE,
PQTH.P_WAE
FROM Logbook
INNER JOIN PQTH
ON Logbook.L_CALLID = PQTH.P_CALLID
WHERE (((Logbook.L_DATE >= #01/01/2018#)
AND (PQTH.P_WAE <> '%')))

Best 73