This is driving us nuts!, can anybody help...PLEASE

[eclecticbmxer]

Query based controls driving us nuts!, can anybody help...PLEASE

Hello, thanks for reading this.

I have hardly used access before, but my supervisor dumped on me last week the task of improving an existing database. In other words, I have pretty much been working with VBA with no prior knowledge. I have handled my problems fairly well so far (thanks to some members of these forums ) but now I'm really stuck.

I have a table (tblHours) that includes a field for the hours spent each day on a specific task by a certain in a pay period (the pay period, employee ID, and the task ID are separate fields).

I created a query to calculate the total number of hours (fiscal year to date) per task for each employee.

There is a form frmEmployeeHours which contains the subHours subform. The subform is based on tblHours.

My boss wants me to add a control to display the total number of hours worked (fiscal year to date).

I asked a friend that works with me (who knows a great deal more about programming than I) and he is also stumped.

Is there any way to do this without getting into a whole mess of code and the like? Or do I have a truckload of programming in VBA and Access macros to learn before I can finish this task?

I also have another problem with another control my supervisor wants on the form, but that can wait till I have this taken care of.

Thank you for reading all this, PLEASE reply if you have an idea

 

[Jerry Stoner]

If yould like you can zip your db and send it to me. You can strip out real data and add some dummy info if need be. Ill post the solution for those interested.

 

[eclecticbmxer]

Thanks a lot!

I will have to get rid of the data and stick some dummy data in there, but I think I can send it to you.

Thanks again.

 

[Jerry Stoner]

send it here

jstoner@nanotronusa.com make sure you zip it.

 

[eclecticbmxer]

Thanks!!

I have emailed you a copy of the db, however I'm not sure if the security settings go along with it...

I will be leaving work at around 3:30 eastern time. Which is in about 45 minutes.

I will be back in at 7:00am eastern on Monday.

Hopefully, you should have no problems looking at it. If you have any problems, you can email me here and I'll do what I can to help first thing Monday morning.

Again, thank you very much for looking at this for me.

eclecticbmxer