Microsoft KB Archive/45672

Documentation Error Regarding DSUM Function PSS ID Number: Q45672 Article last modified on 07-07-1989 PSS database name: D_MPlan

4.00 4.01

MS-DOS

Summary:

On Page 124 of the “Microsoft Multiplan Addendum” for Version 4.00, the syntax for the DSUM function omits quotation marks that are required around the field name. The correct syntax to be used with the DSUM function is the following:

DSUM(database,“field”,criteria)

The DSUM function adds the numbers in the column of records in the database that satisfy the criteria. DSUM is the database equivalent to SUM.

Copyright Microsoft Corporation 1989.