Just a thought...

From your description it sounds like you might be able to use subreports to
show different aspects of the total information you want to convey.

--
Good luck

Jeff Boyce
Access MVP