QUIZ — the basics

Not to offend the technological professionals –  but Quiz is the report writer for the non-IT elect.

You want a Customer list? That takes nine words:


(or seven words if you don’t care about the sort order).


   Page 1 — the basics
   Page 2 — the result
   Page 3 — the FIVE key words
   Page 4 — find
   Page 5 — where
   Page 6 — print
   Page 7 — sort
   Page 8 — chart

Next – the result >

Print — Repeat

SQL returns every field on every row selected on a query. You often don’t want every field to print on every row. So… we have this reserved word.

Where count and summarize keep track of unique values, repeat deals entirely with consecutive values.  If the values of the records are like this:

A B B C B A A C C B B A  — the printing would be like this:
A B    C B A     C     B     A

There are two forms.

  1. norepeat — skips print of duplicate value
  2. repeat on — accepts modifiers. Whenever the target field or any one of the modifiers change, the field prints.


   Page 1 — repeat
   Page 2 — norepeat
   Page 3 — repeat on
   Page 4 — repeat on page

Next – norepeat >

Print — Summarize

summarize is used in two ways:

  1. For numeric fields, summarize will calculate a running total of the field. The on arguments then determine when the accumulated value prints. When the field prints, the running total is reset to zero.
    Where break will print totals under an existing column, summarize prints its values in a separate column.
  2. For date and text fields, summarize acts as a filter rather than an accumulator. The on arguments determine when the date or text field prints.

All summarize statements require at least one following ‘on’ reserved word.

   Page 1 — summarize
   Page 2 — summarize syntax
   Page 3 — numeric summarize
   Page 4 — date summarize
   Page 5 — expression summarize
   Page 6 — text summarize

Next – summarize syntax >