Summing Totals Problem

[Guest]

Hello, I am having a problem with a Timecard report that prints out each
employee's time for each day worked. I also have another table to track each
time a edit is made to these records that forces the user to put in a
"Comment" as to why it was modified. It also creates a new record in the
comments field for each time a new modification is made to that record. NOW
THE PROBLEM, when i run this query in a report and sum the hours for each
person it doubles or triples the persons hours for the records that have a
comment or multiple comments. I am just wanting to print out the comments on
timecard and not cause the summing of the hours to be inreased. I have the
two tables joined to where all of my Labor records are shown and only the
records of the "Comment" table that match the Labor Table. This is causing
the multiple records to be added and more hours to be summed throwing off the
summed hours totals.

Is there a different way i can approach this? I am relatively new to ACCESS
so please be gentle with responses... THANKS IN ADVANCE!!!

 

[Marshall Barton]

Hello, I am having a problem with a Timecard report that prints out each
employee's time for each day worked. I also have another table to track each
time a edit is made to these records that forces the user to put in a
"Comment" as to why it was modified. It also creates a new record in the
comments field for each time a new modification is made to that record. NOW
THE PROBLEM, when i run this query in a report and sum the hours for each
person it doubles or triples the persons hours for the records that have a
comment or multiple comments. I am just wanting to print out the comments on
timecard and not cause the summing of the hours to be inreased. I have the
two tables joined to where all of my Labor records are shown and only the
records of the "Comment" table that match the Labor Table. This is causing
the multiple records to be added and more hours to be summed throwing off the
summed hours totals.

Is there a different way i can approach this? I am relatively new to ACCESS
so please be gentle with responses... THANKS IN ADVANCE!!!

I think it might be easiest for you to go back to using the
table as thereport's record source and remove all the
comment related stuff. At least the totals will be simple.

To then display the comments, create another simple report
that displays all the comments for all the employees. Add
this repoat to the other report's detail section as a
subreport and set the Link Child/Master properties to the
appropriate employee linking fields.