troubleshooting Question

Can't update fields in datasheet view of a sum query?

Avatar of Drizzt420
Drizzt420 asked on
Microsoft Access
4 Comments2 Solutions477 ViewsLast Modified:
This is going to be a little difficult to explain, so please bear with me...

I have been asked to make a database that keeps track of Employee Tardiness/absenteeism, as well as how many "points" an employee has accumulated.

Every time an employee is absent, tardy, or leaves early - a record gets entered into the database for that date telling whether it was an absence,  a tardy,  a improper call-in, etc - the appropriate point value {which could be anywhere between 0.5 and 2.0) for the type of instance is also recorded.

When an employee reaches a certain point level, they are supposed to recieve one of four types of warnings. (verbal, 1st written, 2nd written, final, termination) When the supervisor looks at the data, he sees each employees point total.

There are 4 yes/no check box fields as well, one for each warning level. If the supervisor sees that an employee has 1 or 1.5 points, and there isnt a check in the "verbal warning" box - then he knows he has to deliver the verbal warning and then put a check in the box to record that it has been done, if the employee has 2.0 or 2.5 points, and there is no check in the "1st written warning" box, then..... .....and so on and so forth, for all warning levels.

My problem is this:  I have a query that shows each employee only once, along with the sum total of thier current points, but I can't seem to edit data using that query, more exactly, I can't update warning level checkboxes.

Is it not possible to edit data in a sum query? I'm also going to need the warning level checkboxes to "uncheck" themselves when the employees point total falls back below the amount needed for a given warning level - I think I can figure out a way to do these things, but not if I can't see the point data added up for each employee in a way that can be edited - How do I accomplish this?
Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros