I have a field containing some values. In edit mode, when I click on any one of these values it gets replaced by 1.#QNAN in the cell.
I would like to query the table for all cells containing 1.#QNAN values. When I try to query for Null values (SELECT FROM .... WHERE .... IS NULL) no rows get selected. So Im assuming SQL doesn't recognize that 1.#QNAN are in fact null values.
How do I get the select by attributes dialog box to select all cells not containing a number?
أكثر...
I would like to query the table for all cells containing 1.#QNAN values. When I try to query for Null values (SELECT FROM .... WHERE .... IS NULL) no rows get selected. So Im assuming SQL doesn't recognize that 1.#QNAN are in fact null values.
How do I get the select by attributes dialog box to select all cells not containing a number?
أكثر...