Good morning, Allen, from rainy Iowa. And thank you for responding.
Actually I have that much of the query done, and I was trying to have a
summary line at the bottom of the report which gives the totals for males and
females (I actually have the "unknown" choice).
The report would read:
Age M F Unknown
10 2 1
11 3
12 3 3
15 1
Totals 5 6 2
Late last night, I finally figured out a report. I read through most of the
crosstab discussions and found a suggestion to just "try different wizard
reports" and found that I was able to add fields to the tabular report that
work. I think one of my fundamental thinking flaws was my lack of
understanding that the "detail" for a crosstab query is actually the lines
reporting the count (not the individual records) and I had the count fields
in the wrong report section.
It also took me a while to figure out that for the fields from the crosstab
query to be available through the wizard, it was necessary to list the column
headings in the properties of the query, and that these column headings had
to be exactly the same as entered in the field ("M," which was the actual
entry, instead of "Male" which is how I wanted the heading to show up on the
report, unless I wanted to create another query).
I'm pretty new to Access, and admit to trying to use as many wizards as
possible. I completed a semester of SQL, which is helpful, sometimes.
.