This is an interesting one. I've got a timesheet form where employees log their hours to a job number (which is populated from the original form/table where it is entered called ProjectInfo). Then back on the Project Info Form I have a box that I want to populated with the totaled hours that either one employee or various employees have logged to that job number.
The way I've been going about it so far is I made a query totaling the number of hours, but then I'm not sure how to get that back into the project for to the specific job number that they are related to (without the user having to choose the job number again from a combo box).
I tried to use an update query to update the field in the Project Info table but that doesn't work for some reason (I think it has something to do with the query I used having sums instead of just a lookup query)
I'm not really sure what the right way is to go about doing this.