How do you have the detail section of a report sort ascending?
I have a report with 1 header and then the detail. The header consists of hourly payroll and salary payroll. When the report prints the hourly / salary groupings are correct, but the dates in the detail are non-sequential, example: 1/2/03
2/5/02
4/6/03
and so on. I have sorted the report query ascending by the date field.
I want the next date to be the next in the detail section. I have had this problem before, but have never really cared. I am guessing it is something.
Thanks for the help.
Greg
I have a report with 1 header and then the detail. The header consists of hourly payroll and salary payroll. When the report prints the hourly / salary groupings are correct, but the dates in the detail are non-sequential, example: 1/2/03
2/5/02
4/6/03
and so on. I have sorted the report query ascending by the date field.
I want the next date to be the next in the detail section. I have had this problem before, but have never really cared. I am guessing it is something.
Thanks for the help.
Greg