Query for Empty Field

[w0ls]

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

[G4POP]

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

[w0ls]

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

Thanks,
Harry
W0LS

[HB9BRJ]

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

[w0ls]

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