D
David
I have to summarize the usage time for several instruments. I have two
tables in my database. The first, UsageData, contains identifying info for
users and the usage time for various analyses. One of the fields is Advisor.
A second table, NameLookup, contains the fields Institution and Advisor, and
is related to UsageData via Advisor. NameLookup sets the value of
Institution based on Advisor.
My report contains 5 fields - Institution, Advisor, Project, DocID, and
Time. The fields are grouped in the order listed, and the value of Time is
Sum([Time]), as a running sum over the DocID group. The report gets
Institution from NameLookup, and the other fields from UsageData or
calculation. The report should contain one line for each set of data in
which all 4 non-calculated fields are the same. I made a form for the data
entry, and that works fine. I entered a set of data yesterday, and the
report looked as it should.
Background over, now the problems.
I entered more data today, and the report now shows two lines for some data.
The first line appears to be a subtotal of the data entered earlier, and the
second line is the proper group total. It's as if the earlier data is
considered a different data set. Perhaps related to this, for some, but not
all, of the data entered today, the report shows a total that is twice what
it should be. I've moved fields, removed relationships and remade them, and
deleted and recreated tables, all without success.
As a second issue, if the advisor's name isn't in NameLookup, the summary
for that advisor doesn't appear in the report, and there's no message telling
me. I thought about adding a Lookup field to UsageData, but I didn't want to
violate the 2nd commandment at mvps.org.
I'm coming from an old Paradox database (hard drive ate 10 years of data -
backup failed), and a lot of this is Designed In Editor. Suggestions and
advice are welcome. Thanks in advance.
tables in my database. The first, UsageData, contains identifying info for
users and the usage time for various analyses. One of the fields is Advisor.
A second table, NameLookup, contains the fields Institution and Advisor, and
is related to UsageData via Advisor. NameLookup sets the value of
Institution based on Advisor.
My report contains 5 fields - Institution, Advisor, Project, DocID, and
Time. The fields are grouped in the order listed, and the value of Time is
Sum([Time]), as a running sum over the DocID group. The report gets
Institution from NameLookup, and the other fields from UsageData or
calculation. The report should contain one line for each set of data in
which all 4 non-calculated fields are the same. I made a form for the data
entry, and that works fine. I entered a set of data yesterday, and the
report looked as it should.
Background over, now the problems.
I entered more data today, and the report now shows two lines for some data.
The first line appears to be a subtotal of the data entered earlier, and the
second line is the proper group total. It's as if the earlier data is
considered a different data set. Perhaps related to this, for some, but not
all, of the data entered today, the report shows a total that is twice what
it should be. I've moved fields, removed relationships and remade them, and
deleted and recreated tables, all without success.
As a second issue, if the advisor's name isn't in NameLookup, the summary
for that advisor doesn't appear in the report, and there's no message telling
me. I thought about adding a Lookup field to UsageData, but I didn't want to
violate the 2nd commandment at mvps.org.
I'm coming from an old Paradox database (hard drive ate 10 years of data -
backup failed), and a lot of this is Designed In Editor. Suggestions and
advice are welcome. Thanks in advance.