ACCESS / AQL

grand-total modifier

The grand-total modifier substitutes a string of text in place of the standard "***" literal string normally output on the grand total line. This produces a grand total only in sentences that include the total modifier. Multiple options may be enclosed in the same set of single quotation marks.

Syntax

grand-total "{{text} {’options’}...}"

Parameter(s)


`text`	Text to display on the grand-total line.
`options`	’l’	Suppresses the blank line preceding the grand total.
	’p’	Issues a form feed (page eject) before the grand total.
	’u’	Double-underlines all totaled fields.
	’’	(Two single quotations marks.) Inserts a single quotation mark in text.

Example(s)

list journal by company by salesman with age > "120" amount.due salesman
company total amount.due grand-total "Total"

See also

break-on modifier→det-supp modifier→Modifiers→roll-on modifier→xr (running subtotal) processing code→total modifier→