Grouping Question

[gkl]

Dear All,

I have a query that is looking at an Orders table and it is extracting information about the order id, total cost, department placing the order and date on which the order was placed.

I want to do a report that presents the information and groups them first by department and then by the year in which the order was placed, no problem so far.

My problem is that once the report is generated I can see a header and footer for the Department grouping (Level 1), but not for the Date grouping (Level 2). Is that by design or have I forgotten something? How can I have a footer for Year grouping as well (Level 2)?

One other thing I was trying to do is add in the footer the most popular month for recruitment for each department (e.g. Marketing got most of its new recruits in April), but I couldn't figure out a way of doing it from the aggregate functions on offer from Access. Could someone advice on how I might go about this?

Regards,
George

 

[MarkK]

There is a grouping and sorting interface in report design. It shows the grouping that has been defined for a report, but the thing is that a grouping in a report is not required to have a header or a footer, and the grouping interface is different in different version of access.
What I suggest is open your report in design view, and turn on the Group & Sort, or Group & Total interface. Find the group in there, and open it, and make sure that the group has a header, let's say. Then you can put controls in that header, and even run code when that header is formatted, so you can run and display summaries at that time.

Hope this helps,

 

[gkl]

There is a grouping and sorting interface in report design. It shows the grouping that has been defined for a report, but the thing is that a grouping in a report is not required to have a header or a footer, and the grouping interface is different in different version of access.
What I suggest is open your report in design view, and turn on the Group & Sort, or Group & Total interface. Find the group in there, and open it, and make sure that the group has a header, let's say. Then you can put controls in that header, and even run code when that header is formatted, so you can run and display summaries at that time.

Hope this helps,

Thanks Mark, the header is fine - it is actually the footer that I am not getting.

Also, could you please provide some advice on how to fill in the most popular recruitment month idea?

Regards,
George

 

[MarkK]

Did you find the grouping interface? There are numerous properties you can set, one of them being the presence of a footer.

"Most popular month" is a concept of yours that you need to define. Maybe it is the month in which most revenue occurs, or the month in which most records are added. Maybe you need to count records. Maybe you need to sum fields. You need to tell us how to calculate it, not the other way around.

Your best bet solving a problem like this is 1) describe the outcome you expected, 2) describe what you tried, 3) describe how those efforts failed. If this is all you say, "I couldn't figure out a way of doing it," then there's a good chance I'll suggest something you already tried, which is a waste of both of our time.

Hope this helps,