Link to home
Start Free TrialLog in
Avatar of Drizzt420
Drizzt420

asked on

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

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?
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Drizzt420,

Your question WAS answered (so it shouldn't be deleted).

The bottom line is that you cannot edit queries that contain aggregate functions.  You have to use some workaround.  I explained this and suggested a workaround in my first comment.

LukeChung-FMS also provided you with an excellent resource.

Even though these work-arounds were not usable to you, they did answer your original post as well as possible given the feedback provided, so the points should be split between the comments.

I would have been happy to continue the discussion here, and I'm sure LukeChung-FMS would have been as well, if you had responded to our comments.  ;)




Starting the automated closure procedure to implement the recommendations from the participating Expert(s).

Mod_MarlEE
Community Support Moderator