Report with dlookup using criteria from group field

[KHoff]

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 Classname. Or is there a better way to do this?
Since it is a crosstab query, I can't bring the extra fields (teacher name)into the record source. Thanks.

 

[khawar]

You can add extra fields in crosstab queries

 

[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 lines? Thanks.

 

[khawar]

How Many row headers you want

 

[khawar]

I think you are doing it through crosstab wizard

You can complete your query through wizard and then open the query in design view and add further row headers you can add as many as you want

 

[asmstrsty]

Great work .. really informative .. and thanks a lot for sharing ..