On Thu, Apr 16, 2020 at 3:07 PM Udo A. Heinze
<uaheinze@...> wrote:
I am trying to come up with the following report:
I want to see Grid Squares that I have worked but not confirmed in my VUCC.
Specifically I sort my log for say only 6 meter contacts. Then go to the progress tab and hit the Progress Key for VUCC. It gives me all the grids I have on 6 meters, both worked and confirmed.
How do I get to a report that ONLY gives me those grids (and the contact info) that I have worked but NOT confirmed?
Fun! Not sure if there's an easier way, but the following filter
should match any 6m QSO where any of the 4 grids is (W)orked. You
could then generate a report (keeping the filter in place), or make a
script.
Band = '6m' and EXISTS (SELECT VUCCProgress.M6 FROM VUCCProgress WHERE
(VUCCProgress.M6 = 'W' and VUCCProgress.Grid in (Left(Gridsquare, 4),
Left(App_DXKeeper_Grid2, 4), Left(App_DXKeeper_Grid3, 4),
Left(App_DXKeeper_Grid4, 4))))
Not thoroughly tested, but the result seems reasonable for my log.
73,
~iain / N6ML
iain macdonnell