I am trying to get data to display in this fashion.
Joe Smith -----12----34---56----24
Under each months name I have a text box linked to a CrossTab Query. The CrossTab Query allows me to put the scores from each month on the same line as a students name, however the Query only has data from months that were tested.
If only one child took a test in November, that month becomes a Column Heading on the CrossTab Query. In the Table or Report that references the Query, ever other child who didn't take the test will have a Null value for November. I like and want that.
If no child took a test in December, however, December doesn't even show up in the CrossTab Query. Therefore, my Form or Report that references December gets an error message. :(
A CrossTab Query has been the only way I have found to have a years worth of results show up on one record line with a child's name. Is there a better way to get the information?
Is there a way to supress the error message and just show a Null value?
Attached are two examples of the type of reports I am trying to generate. Hopefully this will help you to better understand what I want.