I am building a database to show operator errors being run monthly. I am using a tick box with the yes/no arguement to select each error an operator makes on a daily basis.
On my report i want it to show the total number of each error (there are 5 errors which can be selected) that each advisor makes on a monthly basis, and a total number of each error that is made over the whole department.
How can i set the report to show this?
Say the errors are getting the customers Name, Date of Birth, Address, Phone Number and Occupation wrong.
Using the tick box with the yes/no arguement i can select each time the error is made, yet i want it to show how many times on a monthly basis, that each operator made that mistake.
Then on a second report, to show how many times in a month a customers name was spelt wrong (over the whole department with 20 advisors in the department)
I already have the date/month function sorted, it is just the problem of what coding i need to build in my expression to calculate the total errors i need that is the problem.
I have seen in report examples that they build expressions into them to calculate selected types, but i do not know how to find the total selected using the tick box function (which i do need to use to create the data for the report)
This thread is now locked and can not be replied to.