ACC: Behavior of Query Differs for Byte Data in MS Access 95/97Last reviewed: July 15, 1997Article ID: Q168875 |
The information in this article applies to:
SYMPTOMSNovice: Requires knowledge of the user interface on single-user computers. When you create an update query that calculates values for a numeric field, and you set the Field Size to Byte, you may not achieve the results you expect when the calculated value in the field is larger than what the Byte size data type can hold. The following behavior will occur if this happens.
In Microsoft Access 7.0 and 97The query updates the value in the field to the calculated value minus 256.
In Microsoft Access 2.0The query does not update the field, and you receive a conversion error message.
CAUSEThe Byte data type is used to store small, positive integers ranging from 0 to 255.
RESOLUTIONUse a different field size for your calculated field if you are going to be creating calculations that exceed 255.
MORE INFORMATION
Steps to Reproduce Behavior
REFERENCESFor more information about field sizes, search the Help Index for "fields, size," or ask the Microsoft Access 97 Office Assistant. |
Keywords : kbusage QryProp QryUpdat
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |