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 below. 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 |
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