Home > MultiValue Central > Online D3 Reference > Access: Verbs > access.sum

access.sum

Verb: Access/Access: Verbs, Releases: AP and R83

Displays total of numeric field.

Syntax

sum file.reference {itemlist} attr.name {sellist} {modlist} {(options)}

Description

produces a numeric total of a given attribute for all items meeting the optional selection criteria.

If an 'attr.name' (attribute name or number) is not specified, the total number of characters in the selected items are calculated.

If only the file.reference is specified, the total number of characters in the entire file is calculated, including attribute and value marks.

Options

* see 'options: Access'.

Example

sum invoices amount (p

See Also

Command Name Type Description
access.options Definition Standard options: b,c,d,h,i,j,k,n,p,r,s,u,y
access.itemlist Definition Defines a specific list of item-ids.
access.sellist Definition Defines selection criteria portion of an Access sentence.
access.selection.criteria Definition Description of Access selection criteria.
access.modifiers Definition List of Access modifiers.
access.stat Verb: Access Displays total and average of numeric field.
access.attr.name Attribute Defining Item Specifies item(s) from the dictionary of the file.
access.count Verb: Access Counts items in a file.
access.verbs Definition General form of Access sentences.

User Comments

What do you think?

Share your experience or ask a question by using the form below.

Login to leave your comments.