I have a database where a person is able to enter the different tasks
they do each day by specific department and matter.
On a form they enter the date, their name, and their title; in a
subform they select from a drop down list what department/section this
task pertains to and then they select the matter they are discussing
or working on with that department. They enter the time they spent on
this matter and they also enter some more detailed information in a
memo field. The details aren't necessary for my summary calculations,
that's basically just for their own information.
Anyway, my problem is that I have created this report that takes the
information from a query that filters out all entries made for a
specific person and time period. It then adds the time entered per
matter and displays what percent of their time is spent on each matter
type for the specified time period. I also have a very similar report
that displays what percent of their time is spent on each department
for the specified time period. The report works just like I want it
to, but it displays the same report multiple times.
For example, if I select a time period of 11/22/04 to 11/26/04, the
report will summarize all data for those five days. The calculations
are just fine, but it repeats the report on five pages; one for each
day in the time period.
I hope this makes sense and I hope someone has an idea of what I'm
doing wrong. I've stared at this thing for weeks and I just don't see
what's happening.
Thanks in Advance,
Jessica
je********@hotmail.com