Home  |  About  |   Search   

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

RunCommand Constants

Terms of Use


 

Bugs: Using Group by along with NZ results in unreadable characters

Author(s)
Alden Streeter
  Steps to duplicate:
  1. Create new a table called Table1. 
  2. Create an Integer field (actually any numeric field seems to work) called intField1 in the table, and save.
  3. Open the table and add a few records 
  4. Create a new query with this SQL:
    SELECT Nz([intField1]) AS Expr1
    FROM Table1
    GROUP BY Nz([intField1]);
  5. 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]))


1998-2009, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer