How to do a both/neither/one/other tally
A routine check I do on data tables is to see if paired fields are either both filled or both empty in each record. By "paired fields" I mean, for example, a latitude field and a longitude field. It doesn't make much sense to have a latitude without a longitude, or vice versa! The command described here will tally up the "both filled", "both empty", "only the first filled" and "only the second filled" entries.
|
|
Full Story |
This topic does not have any threads posted yet!
You cannot post until you login.