Richard,
I have a Response form for each of the households that return the survey.  The main form has the name and information that I need to fill in, such as #of persons in household, combined income, #Over 65 and #Under 18.
The Sub form has information that I can pick from drop down boxes (gender, years at address, marital status, and comments.

This is the point where I am stuck.  I would really like to generate two reports.  The first would list all of the survey responses sorted by household.

The second needs to have the counts or sums of each response (count of male, count of female, sum of persons Over 65, Rate of Return, % Moderate Income, % Low Income, Average Income, etc.).

If you can get me to that point, I think that I will be able to set the detail section of the report as not visible and then put all of the calculations in the report footer.

I tried a crosstab query, but I don't know how to use this in a report.

Any help you can give me will be very much appreciated.