cross query

[referee]

hi all

in a crosstab query i have the following problem
in the daynumbers 1 to 5 i see the total nummer of the name
thats not i want to see
what i want to see is just the names (naam) and not numbers
can someone help me with this please

thanks

 

[amolin]

Please try this, by the way if you have deferent name under your group combine, then this code is not work..

 

[referee]

Hi thanks for the example
in attachment i have 2 more fields (team and code)
can i see this also next to the name off the day?
I hope you can help me

thanks