J
Joe Robbo
I have a major problem. I have a query which looks at 3 seperate tables
tblAbsence tblAbsenceLine and tblEmployee. tblAbsenceLine has a
LikelyDuration field which is summed and updated to a Length field in
tblAbsence. Unfortunately when i run the query for every row in the field, it
repeats the Length value from tblAbsence, thus when i Sum this column up in
the report, it gives and incorrect answer. How do i overcome this problem?
tblAbsence tblAbsenceLine and tblEmployee. tblAbsenceLine has a
LikelyDuration field which is summed and updated to a Length field in
tblAbsence. Unfortunately when i run the query for every row in the field, it
repeats the Length value from tblAbsence, thus when i Sum this column up in
the report, it gives and incorrect answer. How do i overcome this problem?