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
|
|||
|
|||
Tell me if this is possible.
I have a report to provide information on employee vacation days, personal
days, etc. The fields a Lastname, Firstname, Date (start of time off), EndDate, TotalDays (DateDiff to determine total number of days between Date and EndDate), and Check Boxes for the different categories of days off (Vacation, Sick, Jury Duty, Personal). My report shows each entry beautifully, now here is the question. At the botton of the page I need a total for each Category, if the days were listed individually it would be easy, so How do I get the report to look at the category and return a total for each so I can complete the rest of my calculations? Help. -- Lori A. Pong |
#2
|
|||
|
|||
Tell me if this is possible.
I thought about that and created a query for the subreport, it seems to only
work half way. When I view the query it's perfect, it shows me the total entitled, the amount used and the balance remaining (the last two is what I need on the report), when I view the subreport it shows me the amount used only if it's zero and then the balance remaining perfectly. I'm confused! -- Lori A. Pong "Michael" wrote: You would probably want to do a group total and then suppress the grouping footer if you don't want to show it there. Then place a copy of that box in the report (or page footer depending on where you want it). I think that will work. I hope I'm explaining it right because it's making sense in my head but sometimes I have to work it out a couple times on my report to get it to work how I want. "Lori" wrote in message ... I have a report to provide information on employee vacation days, personal days, etc. The fields a Lastname, Firstname, Date (start of time off), EndDate, TotalDays (DateDiff to determine total number of days between Date and EndDate), and Check Boxes for the different categories of days off (Vacation, Sick, Jury Duty, Personal). My report shows each entry beautifully, now here is the question. At the botton of the page I need a total for each Category, if the days were listed individually it would be easy, so How do I get the report to look at the category and return a total for each so I can complete the rest of my calculations? Help. -- Lori A. Pong |
#3
|
|||
|
|||
Tell me if this is possible.
You would probably want to do a group total and then suppress the grouping
footer if you don't want to show it there. Then place a copy of that box in the report (or page footer depending on where you want it). I think that will work. I hope I'm explaining it right because it's making sense in my head but sometimes I have to work it out a couple times on my report to get it to work how I want. "Lori" wrote in message ... I have a report to provide information on employee vacation days, personal days, etc. The fields a Lastname, Firstname, Date (start of time off), EndDate, TotalDays (DateDiff to determine total number of days between Date and EndDate), and Check Boxes for the different categories of days off (Vacation, Sick, Jury Duty, Personal). My report shows each entry beautifully, now here is the question. At the botton of the page I need a total for each Category, if the days were listed individually it would be easy, so How do I get the report to look at the category and return a total for each so I can complete the rest of my calculations? Help. -- Lori A. Pong |
#4
|
|||
|
|||
Tell me if this is possible.
Unless I missed something, there is no need for a sub report.
If you use the Sorting and Grouping options of the report, you can group by category. Then you can use a Group footer to sum the days for each category. Then use the report footer to sum the days for the entire report. Also, I would do the calculation of the number of days in the report rather than in the query. It would be faster. -- Dave Hargis, Microsoft Access MVP "Lori" wrote: I thought about that and created a query for the subreport, it seems to only work half way. When I view the query it's perfect, it shows me the total entitled, the amount used and the balance remaining (the last two is what I need on the report), when I view the subreport it shows me the amount used only if it's zero and then the balance remaining perfectly. I'm confused! -- Lori A. Pong "Michael" wrote: You would probably want to do a group total and then suppress the grouping footer if you don't want to show it there. Then place a copy of that box in the report (or page footer depending on where you want it). I think that will work. I hope I'm explaining it right because it's making sense in my head but sometimes I have to work it out a couple times on my report to get it to work how I want. "Lori" wrote in message ... I have a report to provide information on employee vacation days, personal days, etc. The fields a Lastname, Firstname, Date (start of time off), EndDate, TotalDays (DateDiff to determine total number of days between Date and EndDate), and Check Boxes for the different categories of days off (Vacation, Sick, Jury Duty, Personal). My report shows each entry beautifully, now here is the question. At the botton of the page I need a total for each Category, if the days were listed individually it would be easy, so How do I get the report to look at the category and return a total for each so I can complete the rest of my calculations? Help. -- Lori A. Pong |
Thread Tools | |
Display Modes | |
|
|