Printing an array in an access report

[toolsgg]

I need to add sub-totals toa report that are printed at the end of a higher
level group (eg print employee totals at the end of each month wher employee
records are at the detail level and month is a group level)

I can accumulate this data in an array but don't know if there is a way to
print the array in the month group footer.

As an example, it would need to look something like:

Employee 1 10
Employee 1 15
Employee 2 12
Employee 2 17
Employee 1 2

Month 1 totals
Employee 1 27
Employee 2 29

etc.

 

[Perry]

You need to aggregate some more by making a groupfooter for Emloyees as
well.
Play around with both group footers (Month and Employees) to get you the
correct formatting.

 

[toolsgg]

The problem is that the user doesn't want the employee totals after each
employee only at the end of the month. I don't think you can do this using
group totals.

 

[Perry]

Then you'll have either aggregate the employee totals in yr query or
use a subreport to build in the extra aggregation level.
-------------------------------------
Krgrds,
Perry

System parameters:
POS: WinXP SP2
MSO: MSOffice 2003 SP2
DEV: VS8 (dotnet)
-------------------------------------