Database Report May Display Incorrect Results (87646)


The information in this article applies to:

  • Microsoft Works 2.0
  • 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 "ERR" 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
Modification Type:MajorLast Reviewed:9/26/2003
Keywords:KB87646
©2003 Microsoft Corporation. All rights reserved.