Microsoft KB Archive/109569

= WD: Updating DATABASE Field May Change Results =

Article ID: 109569

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Word 6.0 Standard Edition
 * Microsoft Word 6.0a
 * Microsoft Word 6.0c
 * Microsoft Word 95 Standard Edition
 * Microsoft Word 95a
 * Microsoft Word 97 Standard Edition

-



This article was previously published under Q109569



SYMPTOMS
The contents of a DATABASE field may change when you re-sort (update) by the same criteria if the data types in one column are not consistent.



CAUSE
Word will use the first entry in a field (column) to determine what data type is in that field. If a column contains different data types, the sort order will vary if the first element is numeric, text, or date.

For example, the following database will have these three results when sorted:   Original        First sort:      Second sort:      Third sort: numeric         alphabetic        date ==============================================================  24              banana           01/8/92           24 5              apple            12/12/93          5 banana         01/8/92          24                apple apple          12/12/93         5                 banana 12/12/93       5                apple             01/8/92 01/8/92        24               banana            12/12/93 Fields with consistent data types will sort or update consistently within Word.

Additional query words: 6.0 odbc winword word6 7.0a word97 6.0a 6.0c 7.0 word95 word7

Keywords: kbfield kbmerge KB109569

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.