I am making a form where users can select what information they want on a report. (Filtering)
But I want more.
When I manually make a report I can select "Sorting and grouping" (or something, different language). And then give it a page header.
There's a table with ppl. Man and women. On the report you want it sorted by man/woman. First you want man to show up in the header, after that all the records that are man. Then you want woman to show up in the header, with the records that are women.
Above example is to make it clear.
I can do it when I manually make a report. But I can't find any way to do that from a form or query.
Any suggestions? I know it's not very clear the way I explained. It's just the lack of proper words. I guess...