These three commands will do almost what you want, (Tools/Advanced/Database Commands:
Quote:USE LOG
SELECT DISTINCT GRID FROM LOG WHERE !EMPTY(GRID) AND (LOTW_RCVD="F" OR QSL_RCVD="F") AND MODE="CW" ORDER BY GRID
SELECT TMP
COPY ALL TO C:\GRID3.TXT TYPE SDF
Copy and paste the commands into the command window. You don't need to retype.
I say it will almost do what you want, because this example does the CW mode. If you mean Propagation Mode, which is a user-defined field, then you will need this command instead of the 2nd above:
Quote:SELECT DISTINCT GRID FROM LOG WHERE !EMPTY(GRID) AND (LOTW_RCVD="F" OR QSL_RCVD="F") AND CAST(GETUSERFIELD("PROP MODE") AS C(3))="SAT" ORDER BY GRID
Tnx & 73,
Dennis WN4AZY
