Automatically identify rows with an empty attribute

In a social.answers forum, Sue asked if there was a way to automatically copy rows that had a blank value in a particular column. See http://social.answers.microsoft.com/Forums/en-US/excslcreate/thread/dd6af3c8-5801-43c0-86f4-a668cdc3fd85 As a fan of using SQL, particularly through MS Query, I came up with the following. Suppose we have a table with 3 columns, with a few empty values …

Continue reading ‘Automatically identify rows with an empty attribute’ »