Grouping in a Report

[Guest]

I have created a report that is grouped by job. within the job it tells me
expenses and income per job within 4 accounts. I want to group the report as
well by the event date with the oldest job first. I have tried multiple ways
of grouping but each time it does not group the jobs by date as they are. Is
there a way I can take this existing report and get the oldest job to be in
ascending order based on the event date.

 

[Arvin Meyer [MVP]]

In the sorting and grouping dialog box add the event date, but don't use a
group header or footer, just sort on each value (ascending).

 

[Guest]

I tried that but it did not change the report order. I tried by group instead
of sort, it too did not change it.

 

[Arvin Meyer [MVP]]

Did you have a control with that field within the group that you wanted to
sort? It doesn't have to be visible, but it does have to be there.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Guest]

I have the report grouped by job. Within the record set I have expenses,
income and account. In the job header, I have the event date. I have tried to
create a group first by event date and then by job. I have tried group by job
and then by event date, but neither sort the job so the event date is
assending. Each job record set has the event date as the same event date per
job.