Re: SQL filters
Dave AA6YQ
>>>AA6YQ comments below
From: dxlab@... [mailto:dxlab@...] On Behalf Of Stephen Rabinowitz
Sent: Sunday, October 27, 2013 8:04 AM To: dxlab@... Subject: Re: [dxlab] SQL filters
Thank you, Iain, that worked perfectly. My SQL filter is now:
((BAND='20M') OR (BAND='15M') OR (BAND='10M')) AND (MODE='SSB') AND ((EQSL='Y') OR (LOTW='Y')) AND ((ORIGIN='NA-M') OR(ORIGIN='NA-E')) AND (NEEDED='D') AND (CountryProgress<>'F') AND (LastTime > DateAdd("n",-60,Now()))()))
>>>If you enable Realtime Award Tracking for IOTA, Marathon, VUCC, WAS, WAZ, or WPX, you should replace
(NEEDED='D')
With
(NEEDED like '*D*')
>>>If you update your log to reflect the granting of DXCC credits, you should replace
(CountryProgress<>'F')
with
((CountryProgress<>'F') and (CountryProgress<>'V'))
73,
Dave, AA6YQ
|
|