form grouping

[jenske]

hy

i have created a report based on a query designed to print how many days of vacation per type of vacation everybody has taken.


the groups on employee name.
in this groups header the data is shown

now i have to calculate the totals per type of vacation and i have but the problem is i don't know where to place them.

if i place it in the employee name footer it put's in between every employee.

if i place it in the page footer it puts it at the bottem of the page.

is there another group where if you put data in it it comes directly under the last employee name header.(detail section is empty)

 

[THWatson]

jenske
By the types of vacation, do you mean "Regular", "Without Pay", etc. - stuff like that?

If that's the case then I assume you have a field that is something like VacationType. You could then put a DCount expression in the Report Footer. An expression such as...
=DCount("VacationType","YourTableOrQuery","[VacationType]="Regular"")

Then repeat this for the other vacation types.

An alternative would be to do a Totals query, totalling the Vacation types and use this in your report.

There may be other ways, but these would work.
Tom

 

[jenske]

thanx for the help and for the quick response