|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Total field only displays total from first line of report.
I have a report that displays feedback received per month with several sub categories.
In the page header i have these titles; Month Total Escalated Resolved Resolved <21 Days Resolved >21 Days Method I then have a MonthName Header to break up the feedbacks received by month. Also in the header i have a Total field. I would like this field to count the number of feedbacks received in total for each month. I couldn't work out how to insert an image so this is kind of what my report looks like. Month - Total - Escalated - Resolved - <21 - >21 - Method --------------------------------------------------------- October 6 Yes - 6 - 6 - 0 - Email Yes - 1 - 1 - 0 - Fax Yes - 9 - 9 - 0 - Telephone --------------------------------------------------------- September 8 Yes - 8 - 8 - 0 - Email Yes - 4 - 4 - 0 - Fax --------------------------------------------------------- What my report is doing is only giving me the total from the first line. October 6/September 8, what the total should be is October 16/September 12. Again as i couldn't paste a picture, here is the SQL: SELECT qry_UpdateRecords.MonthName, qry_UpdateRecords.MonthNumber, Count(qry_UpdateRecords.FeedbackNumber) AS CountOfFeedbackNumber, qry_UpdateRecords.EscalatedYN, Count(qry_UpdateRecords.EscalatedYN) AS CountOfEscalatedYN, Count(qry_UpdateRecords.ResolvedYN) AS CountOfResolvedYN, Sum(qry_UpdateRecords.[Resolved<22]) AS [SumOfResolved<22], Sum(qry_UpdateRecords.[Resolved>21]) AS [SumOfResolved>21], qry_UpdateRecords.Method FROM qry_UpdateRecords GROUP BY qry_UpdateRecords.MonthName, qry_UpdateRecords.MonthNumber, qry_UpdateRecords.EscalatedYN, qry_UpdateRecords.Method ORDER BY qry_UpdateRecords.MonthNumber DESC , qry_UpdateRecords.Method; I hope i am just missing something really simple, any help would be greatly appreciated. |
|
#2
|
|||
|
|||
|
I have resolved this issue.
Created a calculated field in the report as follows: =Sum(qry_LoggedByMonth!CountOfFeedbackNumber) |
![]() |
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Total field only displays total from first line of report. |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|