If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Grouping not working right
I have created a report with three "groups"
1) Candidate -- there are many candidates 2) Year -- there are 3 years (2010, 2009, 2008) 3) Category -- there are two categories (billable, non-billable) It works fine until it gets to the third category. It then prints all the billable with a total and then a total after each non-billable detail. Thus: billable detail 1 detail 2 detail 3 detail 4 total billable non-billable detail 5 total non-billable non-billable detail 6 total non-billabe non-billable detail 7 total non-billable grand total Any thoughts would be appreciated |
#2
|
|||
|
|||
Grouping not working right
When I have something like this happen, I check the data and then recheck
the sorting and grouping. Access reports are very reliable when grouping. They have always displayed exactly as I have asked them to. Some times this is not what I wanted them to do. -- Duane Hookom MS Access MVP "Richard" wrote in message ... I have created a report with three "groups" 1) Candidate -- there are many candidates 2) Year -- there are 3 years (2010, 2009, 2008) 3) Category -- there are two categories (billable, non-billable) It works fine until it gets to the third category. It then prints all the billable with a total and then a total after each non-billable detail. Thus: billable detail 1 detail 2 detail 3 detail 4 total billable non-billable detail 5 total non-billable non-billable detail 6 total non-billabe non-billable detail 7 total non-billable grand total Any thoughts would be appreciated |
#3
|
|||
|
|||
Grouping not working right
On Apr 17, 11:58*am, "Duane Hookom" wrote:
When I have something like this happen, I check the data and then recheck the sorting and grouping. Access reports are very reliable when grouping. They have always displayed exactly as I have asked them to. Some times this is not what I wanted them to do. -- Duane Hookom MS Access MVP "Richard" wrote in message ... I have created a report with three "groups" 1) *Candidate *-- there are many candidates 2) *Year -- there are 3 years (2010, 2009, 2008) 3) *Category -- there are two categories (billable, non-billable) It works fine until it gets to the third category. *It then prints all the billable with a total and then a total after each non-billable detail. Thus: billable detail 1 detail 2 detail 3 detail 4 * * *total billable non-billable detail 5 * * total non-billable non-billable detail 6 * * total non-billabe non-billable detail 7 * *total non-billable grand total Any thoughts would be appreciated- Hide quoted text - - Show quoted text - Not sure why it worked, but I deleted and re-added the troublesome group and it worked fine. Guess it will be one of life's little mysteries. Thanks for your help |
Thread Tools | |
Display Modes | |
|
|