Microsoft KB Archive/87646

= Database Report May Display Incorrect Results =

Article ID: 87646

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a

-



This article was previously published under Q87646



SUMMARY
When you print, preview, or copy output from a database report, the resulting output may be incorrect if all of the following conditions exist:

 A formula field is included (field contents) in the report. The formula in that field references another field with text entries instead of values. For example:

=FIELD1 * 20

where FIELD1 is a text entry. The database is sorted from Report view.



MORE INFORMATION
The incorrect output will be one of the following:


 * An incorrect value. This occurs only in fields that contain comparison formulas, such as the IF function.
 * An &quot;ERR&quot; message
 * The text entries from the referenced field

These results, will temporarily change the data in that field (that is, list or form views) until the file is saved. The incorrect output will resume as soon as the report is sorted, previewed, or printed again.



WORKAROUND
Change the text entries to actual values.

NOTE: Works for Windows does not support text string functionality. Therefore, formulas cannot reference text entries, only numerical entries.

Microsoft has confirmed this to be a problem in Works version 2.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional Reference Word(s): 2.00 DB DBForm DBReport text functionality

Keywords: KB87646

-

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

© Microsoft Corporation. All rights reserved.