J
Jim Jones
I have a crosstab query which analyses examination results. For a given
subject, the query counts the number of students with each grade (A, B, C,
etc) (the columns) in each of a number of schools (BW800, BW801, etc) (the
rows). If there are no students in a particular grade at a school, I use the
nz function to report zero. If there are no students for the subject at a
school, each cell in the row should contain zero, and I need the row to be
reported. However, in the event, such a row is not returned.
What can I do to get all rows returned regardless of the contents of the
cells - even when all the values are zero.
Any help would be much appreciated - as ever.
Jim Jones
subject, the query counts the number of students with each grade (A, B, C,
etc) (the columns) in each of a number of schools (BW800, BW801, etc) (the
rows). If there are no students in a particular grade at a school, I use the
nz function to report zero. If there are no students for the subject at a
school, each cell in the row should contain zero, and I need the row to be
reported. However, in the event, such a row is not returned.
What can I do to get all rows returned regardless of the contents of the
cells - even when all the values are zero.
Any help would be much appreciated - as ever.
Jim Jones