Another good answer Valis, but you may come unstuck on the test for zero.
This depends heavily on what type of field 'Field' is.
I'm going to assume that the field is a simple numeric field and then I can forget about formatting.
If it's actually a string (formatted currency value for instance) then I would suggest converting the result to a numeric as
CDbl([Field]). This avoids any hiccoughs with data entry or confusion over the exact format (it's also more reuseable code).
Also, I will use the Nz() function to avoid having to use 'OR' and to do it in one test.
- SELECT *
-
FROM tbl
-
WHERE (Nz([Field], 0) = 0);
or, for the string version
- SELECT *
-
FROM tbl
-
WHERE (Nz(CDbl([Field]), 0) = 0);