So right click inside the report and go to Sorting and Grouping, add a group on the Hotal field and sorts on those fields you want sorted. Don't try to do it in the query of the report but in Sorting and Grouping.
Bulzie
I have a form with TABs and subforms. i found that i would not edit those subforms , is that any reasons?
Not sure what you are asking about the Tabs and subforms? The Original post was about sorting and grouping in a report. Did you get that issue resolved?
Bulzie
Sorry, there is another issue, may be i have to re post it
the problem seems not really solved
it is not real 1.1, 1,2 but 1.1 & 1.1 etc...
Eric
So the sort on PAIRNO is not sorting correctly? If so it is probably a text field and not numeric. Maybe in the query on the form/repot try to use the Val function:
vPAIRNO: Val([PAIRNO])
and use vPAIRNO in your forms/report.
Thanks - Solved