Tell me if this is possible.

[Lori]

I have a report to provide information on employee vacation days, personal
days, etc. The fields are: 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]

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!

 

[Michael]

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.

 

[Klatuu]

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.