Reports, your help please...
Dear Colleagues,
I would like to ask your help…
I would like to learn a bit about the language to make reports, Could you please inform about books or website?
And now I am looking for help to a given report:
I am creating a report for QTH Locator, but I only want to have the first 4 digits (ie IN51ra I only want to have IN51)
Could you please help?
Many thanks
73 Manuel Fernando
Here is my Report:
SELECT QSO.L_DATE AS [Date],
QSO.[Band] AS [Band],
QSO.Mode,
QSO.P_DXCC AS DXCC,
QSO.L_QSL_RECEIVED AS QSLR,
QSO.L_Call AS Call,
QSO.MY_CALL,
QSO.L_LOTW_RECEIVED AS LOTW_RECEIVED,
QSO.P_QTHLOCATOR AS QTHLocator,
QSO.L_eQSL_RECEIVED AS eQSL_RECEIVED
FROM (QSO
LEFT OUTER JOIN INF_DXCC
ON QSO.P_DXCC = INF_DXCC.DXCC)
LEFT OUTER JOIN BANDS
ON QSO.L_BANDID = BANDS.BANDID
WHERE (((QSO.Mode IN('FT8', 'PSK31', 'RTTY'))
AND (QSO.L_QSONR in (SELECT FIRST(L_QSONR)
FROM Logbook,PQTH
WHERE (L_QTHID = P_QTHID and (L_QSL_RECEIVED = 1 or L_LOTW_RECEIVED = 1))
GROUP BY P_QTHLOCATOR))
AND (QSO.P_QTHLOCATOR IS NOT NULL)))
ORDER BY QSO.P_QTHLOCATOR ASC
|