>>How can I check for blank records in a table? I'm sure there's a simple answer to this, but its not coming to me. Help!
>
>Surely EMPTY(),ISBLANK() or ISNULL() helpful, but the best way is not to use APPEND BLANK command in your code and you will never get 'blank' records.
These things happen. Best way is "LOCATE FOR EMPTY(x)" where
x is a key field or some field that you know must have a value
for the record to be valid. I get these all the time when
appending from ascii files or starting work on someone elses
work.
jjh.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn