Gender Issue-why can't I see it?

  • Thread starter Thread starter paulcliman
  • Start date Start date
P

paulcliman

I have a table of information about pupils. The task sounds simple
produce a report showing their year of entry and a count of boys an
girls therein.
I can produce 2 queries from the table (tblchildren with fields "Yea
of Entry" and "gender"), each requiring the Entry Year to be typed i
and then creating a count of boys (or girls). BUT.. how do I combin
these two queries on a report. Or do I? Is there some other way o
doing this?
Is what I want produced by a query or should it be done at the repor
design stage. I've tried both and failed miserably!
Help for a relative beginner would be greatly appreciated.
Thanks in anticipation,
Paul Climance
U
 
You could create a crosstab query that has a row heading of the YearOfEntry,
column heading of Gender and a value of Count Gender.
 
Exactly what I wanted!
Many thanks for your swift response -greatly appreciated.
I MUST find time to get past Chapter 14 of my MS Access 2000 Bible!
Paul
 
Exactly what I wanted!
Many thanks for your swift response -greatly appreciated.
I MUST find time to get past Chapter 14 of my MS Access 2000 Bible!
Paul
 
Back
Top