D
David
I need to keep track of the amount of time an instrument is used. I have two
tables in the database. One table, UsageLog, contains identifying and usage
info, and one of the fields is Advisor. Another table, NameLookup, contains
two fields, Institution and Advisor. NameLookup is there just to get a value
for Institution based on Advisor, and the tables are related via Advisor. I
made a form to enter data, and that part works fine.
My report contains 5 fields - Institution, Advisor, Project, DocID, and
Time. The fields are grouped in the order listed, and the value in the Time
field is Sum([Time]), grouped by DocID (running sum over group). The report
gets the Institution field from NameLookup, and the rest from UsageData or
calculation. There should be one line in the report for each set of records
in which all 4 non-calculated fields are identical. I entered a set of data
yesterday, and the report was fine.
Background over, now the problems.
I entered another batch of data today, and some report lines appear to
contain partial subtotals, followed by a second line with the proper total
for the DocID group. The subtotals appear to be from the data entered
yesterday, as if they were a separate set from the data just entered for the
same Institution, Advisor, Project, and DocID.
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.
Finally, if the Advisor's name is not in NameLookup, no output is made for
that advisor on the report, and no message is generated to let me know. I
thought about using a Lookup field to put a value into an Institution field
in UsageData, but I didn't want to violate the Second Commandment at mvps.org.
I'm coming from Paradox (hard drive ate everything), and a lot of this is
Designed In Editor. Advice and suggestions are welcome. Thanks in advance.
tables in the database. One table, UsageLog, contains identifying and usage
info, and one of the fields is Advisor. Another table, NameLookup, contains
two fields, Institution and Advisor. NameLookup is there just to get a value
for Institution based on Advisor, and the tables are related via Advisor. I
made a form to enter data, and that part works fine.
My report contains 5 fields - Institution, Advisor, Project, DocID, and
Time. The fields are grouped in the order listed, and the value in the Time
field is Sum([Time]), grouped by DocID (running sum over group). The report
gets the Institution field from NameLookup, and the rest from UsageData or
calculation. There should be one line in the report for each set of records
in which all 4 non-calculated fields are identical. I entered a set of data
yesterday, and the report was fine.
Background over, now the problems.
I entered another batch of data today, and some report lines appear to
contain partial subtotals, followed by a second line with the proper total
for the DocID group. The subtotals appear to be from the data entered
yesterday, as if they were a separate set from the data just entered for the
same Institution, Advisor, Project, and DocID.
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.
Finally, if the Advisor's name is not in NameLookup, no output is made for
that advisor on the report, and no message is generated to let me know. I
thought about using a Lookup field to put a value into an Institution field
in UsageData, but I didn't want to violate the Second Commandment at mvps.org.
I'm coming from Paradox (hard drive ate everything), and a lot of this is
Designed In Editor. Advice and suggestions are welcome. Thanks in advance.