D3Codex
ACCESS / AQL

Modifiers

.md

Modifiers control listing parameters such as double-spacing (dbl-spc), control breaks (roll-on or break-on), column totals (total), and suppression of item-IDs (id-supp), automatic headings (hdr-supp or col-hdr-supp), and default messages (ni-supp).

Other modifiers and options are listed as follows. For a detailed description of each connective, refer to the individual topics.

any

break-on

by-dsnd

by-exp

by-exp-dsnd

c/total

col-hdr-supp

conv

converting-nulls

det-supp

dbl-spc

dict

each

eval

fill

fmt

footing

grand-total

hdr-supp

heading

id-supp

ifno

legend-supp

lptr

ni-supp

nopage

only

roll-on

sampling

ss

tape

tcl-supp

total

using

with

within

without

Relational operators are modifiers used to establish criteria based on the relationship of data to fixed values or other data.

Operators are listed below. For a detailed description of each connective, refer to the individual topics.

after

equal

le

no

and

ge

lt

not

before

gt

ne

or

See also

Access Query Language→Account→break-on modifier→by modifier→by-dsnd modifier→by-exp modifier→by-exp-dsnd modifier→AQL command categories→converting-nulls modifier→count command→dbl-spc modifier→det-supp modifier→dict modifier→fill modifier→footing modifier→grand-total modifier→hdr-supp modifier→id-supp modifier→list command→list-item command (Access Query Language)→listconn command→lptr modifier→ni-supp modifier→nopage modifier→only modifier→Options (Access Query Language)→sampling modifier→sort command→sort-label command→istat command→check-sum command→tape modifier→total modifier→using modifier→with modifier→without modifier→