Report totals not grouping properly

D

David

I have to keep track of instrument usage time for several users. I've
created the tables, input form, and report, and have solved some problems by
reading other posts here. I still have a problem, however.

I have 5 fields in the report - Institution, Advisor, Project, DocID, and
Time. The first 4 fields are text, and Time is a number. The report is
grouped on each of the text fields, and Time is summed as =Sum([Time]) in the
DocID footer. RunningSum is set to No. Institution may contain several
Advisors, which may contain several Projects, which may contain multiple
DocIDs.

Most of the lines in the report are fine, but a few show two values for Time
for the same value of DocID. The total of the two "subtotals" is the correct
value. I'm not certain, but it appears that grouping is also occurring based
on when the data was entered. Several records entered at time A are grouped,
and others entered at time B are grouped separately, even though they're all
part of the same DocID group.

I've changed the Running Sum value and moved fields around, but the results
are the same. Any ideas? Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top