Access Report Grouping problem

Topic

New Reply

I have tried grouping in the query (as shown in the word example of graphics that I am attaching) for this report, but no matter what I do, I can’t seem to get all names listed once in the report. It shows every occurrence of a lab visit.

It doesn’t matter how many times they came, I am only trying to get their TOTAL Time which is working fine…but their names listed only once beside the total time that they visited. HELP

Reply | Quote

Replies

You have a GroupBy on the Time field (you might want to rename that – Time is probably a reserved word in some contexts). Remove that field, or if you are trying to constrain your results to a given period put a criteria on it and set the GroupBy to Where.

Reply | Quote

Can you not HIDE the Detail Band in the Report (Visible Property to false) and just put the Students Name fields into the [TIME] Footer.
And on that POINT should your Report not be based on an SSN Group rather than the TIME Group
Since I asume SSN is the Student Unique ID?

Assuming all you are trying to do is get TOTAL time by Student.

And if this is the case, could you not just Create a Group By Query for the Report

Grouping BY SSN, Last name, First Name and SUMMING [TIME[

Then the results could just go in the DETAIL Band.

Unless I have misunderstood the report requirement.

Reply | Quote

I attach a demo with two alternatives.
I am unclear whether you want a total per student per subject, or just a total per student, so the demo has both.

One issue you will bump into. A time field cannot display more than 24 hours. So if you sum a time field and the total comes to more than 24 hours you will see the wrong result. Anything over multiples of 24 is not display.

So I usually convert the time field into a number of hours (by multiplying by 24) and sum that.

Reply | Quote