Troubleshoot sorting and grouping in a report

What do you need help with?

In a Microsoft Access database (.mdb) or in a Microsoft Access project (.adp):

I want the records in my report to print in the same order in which they appear in the underlying table or other record source.

The records in the groups aren't sorted.

I want the group header to print on the same line as the first detail record.

I want to hide duplicate values that appear in the same group.

In a Microsoft Access database:

The records aren't sorted in the way I expect for my language.