Steps to duplicate:
- Create new a table called Table1.
- Create an Integer field (actually any numeric field seems to work) called
intField1 in the table, and save.
- Open the table and add a few records
- Create a new query with this SQL:
SELECT Nz([intField1]) AS Expr1
FROM Table1
GROUP BY Nz([intField1]);
- And run the query
When I do this, instead of the numbers I entered into the table, the query
returns weird character symbols.
This only occurs if you do a Group By on the field with the Nz calculation.
A workaround for now is to use the CInt function (or equivalent for other
numeric data types) on the result of the Nz function, e.g. GROUP BY CInt(Nz([intField1]))
|