ACC: Incorrect Results Received with DSum() Function (97000)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q97000
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you run a DSum() function, you receive incorrect results.
CAUSE
The DSum() function returns a set of values in a specified set of records
(domain). Typically, you use this function in a text box control on a
report to total the values from a field in a table or query.
If you omit the surrounding quotation marks from the expression argument,
you don't see the expected error message. Instead, you see a value that
is derived by taking the last value of the field from the report and
summing it x number of times (once for each record in the table or query).
RESOLUTION
Surround each argument in the Dsum() function with quotation marks.
STATUS
This behavior is by design.
REFERENCES
For more information about the Dsum() function, search the Help Index for
"Dsum."
Modification Type: | Major | Last Reviewed: | 5/9/2003 |
---|
Keywords: | kbprb KB97000 |
---|
|