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 >