The information in this article applies to:
Novice: Requires knowledge of the user interface on single-user computers. This article applies only to a Microsoft Access database (.mdb). SYMPTOMSWhen you create an update query that calculates values for a Numeric field whose FieldSize property is set to Byte, you may not get the results that you expect when the calculated value in the field is larger than what the Byte size data type can hold. If this happens, the query updates the value in the field to the calculated value minus 256. 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 INFORMATIONSteps to Reproduce Behavior
10, 15, 20
REFERENCESFor more information about field sizes, click Microsoft Access Help on the
Help menu, type "fields, size" in the Office Assistant or the Answer Wizard,
and then click Search to view the topics returned. Additional query words: prb
Keywords : kbusage kbdta QryUpdat QryProp |
Last Reviewed: May 13, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |