By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,241 Members | 775 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,241 IT Pros & Developers. It's quick & easy.

Help! Wierd Report. Summarizing Data.

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Jessica wrote:
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.


The easy way to do this without having to rethink and redesign your
report is to take your controls out of the detail section of the report
and put it into a footer or header. Perhaps you can make the report
header/footer visible. You should also make the detail section invisible.

The detail section of your report is based upon each individual record
returned by the reports underlying SQL or query, which is why it's
repeating itself. For future similar things, the above approach might
be OK, or you could think about using a totals query as the record source.
--
Tim
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.