Report Grouping

[Fireman1143]

I have a report with four (4) fields: DeptType (test), AssignDate (Date), DispatchNumber (Number) and Closed (Bit). All fields are contained in another application and are linked to the Access application. The query does generate the correct information and the Closed field is used as the main criteria.

I have all working except the following formatting problem. I would like it to look like this

DEPTTYPE
AssignDate
AssignDate DispatchNumber

The first two lines are sorted and grouped and my problem is the second line. I have it grouped on Month and it does NOT group all records for that month togeather. Instead I get a few JULY records, then NOVEMBER records, then JUNE records then another bunch of JULY records.

I am trying to first sort by the DeptType (which it does correctly) then by Month of the AssignDate then in the detail section list each records AssignDate and DispatchNumber.

Thanks,
Fireman1143

 

[PaulBricker]

Hard to say exactly what the report sees without knowing how your date field is set up and whether you span multiple years. You might try add a field to your query

MySort:Month(AssignDate)

And then try sorting by this field in your report. You would set the Group On value in the Group Properties to "Each Value" instead of "Month".

Paul

 

[Fireman1143]

Thanks PaulBricker,

Your thoughts put me on the right track and I solved the issue.

Fireman1143