>User is entering 0 (because of someone else's form design) for unknown in statistical data fields, I'm trying to catch which fields are missing data. I'm assuming the obvious solution (since I can't change the coding) is to make the numeric fields accept null values, replace the fields with .null. when I Append Blank and then use isnull() as my criteria for checking for missing ones. I wanted to see if there are other alternatives that I'm not noticing as this solution feels a bit cludgy since I've got other fields that are not numeric types that I will be using the empty() criteria for. Am I making sense, and is this the best solution?
>
>Diana
Diana,
If it's numeric or float you can use isblank(). It doesn't work for int and double. Better is setting null acceptance on.
If user inputs 0 then only way (that I know of) to set it back to blank is 'blank' command (assuming unbuffered and field doesn't accept null where u can't use Ctrl+0).
Null is the way to go because in statistical data 0 has meaning.
Cetin