[Dxbase] WAS90 report list

[Gary Senesac AL9A]

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