I am trying to design a user list project that will generate a listing of the 50 states worked to submit to the ARRL for the WAS90 award. I have used the wizard to select all QSO's between the required dates of April 3 - December 31, 2004. This yields something over 3200 Q's Many of these are DX and have no info in the State field.
When I produce the list I get all of the Q's, 38 pages worth, not just the domestic Q's. I tried using the Empty function to test the State field, but that excludes all states and returns just the DX Q's. I need help in creating the appearance logic for the report that would select a subset of the wizard data that contains only a single QSO from each state. Any help would be appreciated. Using DXbase 2003. (I know, I need to upgrade!). Gary AL9A From [EMAIL PROTECTED] Thu Jan 6 19:26:05 2005 From: [EMAIL PROTECTED] (Jack) Date: Thu Jan 6 19:28:47 2005 Subject: [Dxbase] WAS90 report list References: <[EMAIL PROTECTED]> Message-ID: <[EMAIL PROTECTED]> Gary, The current release already has this as a standard report. Regards, Jack ----- Original Message ----- From: "Gary Senesac AL9A" <[EMAIL PROTECTED]> To: "DXbase Reflector" <[email protected]> Sent: Thursday, January 06, 2005 3:34 PM Subject: [Dxbase] WAS90 report list I am trying to design a user list project that will generate a listing of the 50 states worked to submit to the ARRL for the WAS90 award. I have used the wizard to select all QSO's between the required dates of April 3 - December 31, 2004. This yields something over 3200 Q's Many of these are DX and have no info in the State field. When I produce the list I get all of the Q's, 38 pages worth, not just the domestic Q's. I tried using the Empty function to test the State field, but that excludes all states and returns just the DX Q's. I need help in creating the appearance logic for the report that would select a subset of the wizard data that contains only a single QSO from each state. Any help would be appreciated. Using DXbase 2003. (I know, I need to upgrade!). Gary AL9A ______________________________________________________________ Dxbase mailing list Home: http://mailman.qth.net/mailman/listinfo/dxbase Help: http://mailman.qth.net/mmfaq.htm Post: mailto:[email protected]
