Recent content by KHoff

How? (I am using Access 2000). You can only have 3 row headers, 1 column header and one value field. I am already using all them already. So what do you put in the various rows of the query grid for the extra fields that you want to include. I.e. in the field, table, total and crosstab...

I have a report based on a crosstab query. One field is ClassName. I group on Classname. For each class, I want to show (in page header) other data from table where classname comes from (teacher names). I tried dlookup, but how do I get the criteria to index through the various values of...