Dear Friends,
        One of the staff who seeks my advice from time to time has just
put and entire set of responses to a "multiguess" type questionnaire into
Pdox 5.  THe responses are only Agree, Disagree, Not Sure, Not Applicable.

She has the base details of each questionnaire in the first 6 fields and
then the 30 odd questions make up the next set of fields.

You can run a query to ask how many women, clerical staff (say) said Agree
to Q2.3. but if you want to know how many (of the same group) answered
agree to 2.4 - you have to ask a new query.  I've tried count, and calc
count.  Crosstab seems inappropriateand there doesn't seem to be anything
in Report (although this would be the preferred).

Any ideas before I resort to writing an ObjectPal routine for all this?
Regards, Lloyd.

You're asking '30 odd' distinct questions so why shold there not be 30
distinct queries required.  A script for this is extremely simple -
just loop a query from field.1 thru field.30 - could always write the
results to a single large text db and then output as a single report.

MASTER/PARENT TABLE

Questionairre#    SmallInt
Other Stuff

DETAIL/CHILD TABLE

Questionairre#    SmallInt
Question#         SmallInt  (values of 1 through 30)
Answer Value      Alpha-1   (A=Agree, D=Disagree, etc.)

Now you can get the answers you need. If it is your job to support a
relational database you need to understand what a relational database
is. See if your local library or bookstore has a book that explains
Cobb's Rules for normalizing a relational database. Your tables should
always be what is called third or fourth normal form in Paradox.

Daniel A. Morgan