[Dxbase] WAS90 report list

Thu Jan 6 15:34:49 EST 2005

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