S
SLA
I am trying to create a report that will provide operator activity. To get
all the information, I have linked four tables. I am reporting the statistics
grouped by Operator ID and summing the numbers in the activity columns.
However, I end up with multiple records with the same values per operator ID
and that messes up my sums. How do I stop this? (If it makes a difference, I
have access to the data and to MS Access to create queries/reports but am not
permitted to change the tables or the formats of the data).
all the information, I have linked four tables. I am reporting the statistics
grouped by Operator ID and summing the numbers in the activity columns.
However, I end up with multiple records with the same values per operator ID
and that messes up my sums. How do I stop this? (If it makes a difference, I
have access to the data and to MS Access to create queries/reports but am not
permitted to change the tables or the formats of the data).