Log4OM

I am trying to repair some entries in the log that do not include values for certain fields like Country, State etc. How do you do a search for empty fields? I have tried things like NULL, ' ' etc but no luck. Can anyone help me with this?

Thanks and 73's
Harry
W0LS

Just select the required field and equal to but leave the box where you would normally type the data empty

This equates to:

State field equals empty

That was easy.. I guess I was looking at it from a programmers perspective...you guys made it to easy!!

Thanks,
Harry
W0LS

An alternate approach, useful to get a visual overview about missing or incorrect values in general:
- in QSO Archive > Layout, make your field(s) visible
- set limit (bottom right) to 0 if there are more than 5000 QSOs in database
- click on Search to display all QSOs
- click on a column header to sort the list in ascending order
- click again on the same column header to sort the list in descending order

73, Markus HB9BRJ

Thanks Markus...that works good as well. And I was not aware that you could change the limit...so that was good to know. I was actually trying to go a couple of levels....first country equal US and then state field empty...

73,
Harry
W0LS