This one really has me stumped.
I have an Attendance Tracker that uses a query to update records on an Attendance Table.
Users enter records into the Query using a form which contains a calculated field that assigns an occurrence point value based on the infraction type and time frame.
For example:
If I call out for 8 hrs the calculated field assigns 1 point
If I’m late for 25 minutes the calculated field assigns .25 points
If I leave 3 hours early the calculated field assigns .50 points
…etc.
When users submit the completed form, an Update Query updates the occurrence point value in the Attendance Table.
This is working 95% of the time… the other 5% I encounter an error where the update query posts a DIFFERENT occurrence point value into my Attendance Table other than what’s shown in the Query’s calculated field. For example my Query’s calculated field will show an Occurrence Point value of 1 (correct) but when I run the Update Query it posts a value of .50 (incorrect) into the Attendance Table.
The problem is happening randomly. If I catch the error on a specific record, I can sometimes duplicate the issue if I delete and enter the exact same contents into a new record. Today I caught an erroneous record and was able to duplicate the issue, however when I tried to duplicate it on my backup file (containing the exact same error on the same record) the error would not duplicate and it fixed itself. I also can’t find any commonalities between the records that produce the error.
To recap, the Query’s calculated field is ALWAYS correct 100% of the time. However the Update Query is taking this result and updating the Table with a random (incorrect) number 5% of the time.
I’ve tried compacting and repairing the database, I also moved all the elements into a new database file to see if the original file was corrupt, but the error continues.
Any ideas?
I have an Attendance Tracker that uses a query to update records on an Attendance Table.
Users enter records into the Query using a form which contains a calculated field that assigns an occurrence point value based on the infraction type and time frame.
For example:
If I call out for 8 hrs the calculated field assigns 1 point
If I’m late for 25 minutes the calculated field assigns .25 points
If I leave 3 hours early the calculated field assigns .50 points
…etc.
When users submit the completed form, an Update Query updates the occurrence point value in the Attendance Table.
This is working 95% of the time… the other 5% I encounter an error where the update query posts a DIFFERENT occurrence point value into my Attendance Table other than what’s shown in the Query’s calculated field. For example my Query’s calculated field will show an Occurrence Point value of 1 (correct) but when I run the Update Query it posts a value of .50 (incorrect) into the Attendance Table.
The problem is happening randomly. If I catch the error on a specific record, I can sometimes duplicate the issue if I delete and enter the exact same contents into a new record. Today I caught an erroneous record and was able to duplicate the issue, however when I tried to duplicate it on my backup file (containing the exact same error on the same record) the error would not duplicate and it fixed itself. I also can’t find any commonalities between the records that produce the error.
To recap, the Query’s calculated field is ALWAYS correct 100% of the time. However the Update Query is taking this result and updating the Table with a random (incorrect) number 5% of the time.
I’ve tried compacting and repairing the database, I also moved all the elements into a new database file to see if the original file was corrupt, but the error continues.
Any ideas?