Help with Form

[imintrouble]

Hello! I seem to be having trouble with creating a form which takes all time, in the form of hours and minutes, and adds it all together as new information is introduced. I've already done some research into this matter and some sites said I should create a subform or something but when I tried I was unable to actually get the turn out that I wanted.



Any help would be greatly appreciated.

[alansidman]

Let's start with the tables you have and how they are laid out. Field names and types of fields. Which table is bound to your form. What are you trying to accomplish.

when I tried I was unable to actually get the turn out that I wanted

What does this mean. Without an explanation of your issues and what you specifically want, we don't know what you are trying to do. I apologize, but I left my crystal ball at work and I am lost at mind reading without it.

Help us to help you. Give us more information.

[imintrouble]

Yeah sorry about how vague the statement was. What I ment by the turn out was that the subform failed to actually add all of the hours/minutes together.

Anyways, My table, Hours Worked, contains an autonumber id, First_Name, Last_Name, Date_Worked (date/time type), Strt_Time (date/time type), End_Time(date/time type). I also have a query which holds another date/time field type called HoursWorked which, through a module, takes the time from Strt_Time to End_Time and displays it as hours and minutes.

All I really need is a way to take the total from the HoursWorked field and display it.

[alansidman]

If you are looking to have this displayed in a form, then I would create an aggregate query that Groups on the person and Date Range and sums on a new field that calculates the hours/minutes worked each day.

Make this the record source for your Form that you want to display.

[imintrouble]

Thanks for the tip, however I am still unsure about what you are talking about. I haven't used Access but once and that was a year ago, I would greatly appreciate a step by step instruction. The parts I did understand was that, yes, I would like for the total to be displayed in my form. Unfortunatly this was all I garnered from your answer. sorry, Im a bit thick in the head.

[alansidman]

Perhaps it might be easier if you post your database, and let the folks on the forum look at it. We can then make suggestions based upon your needs, post your database back with changes and explanation of what happened. In this manner, you will learn. In the meantime, I would grab a book or find a tutorial on line on building databases and queries. Unlike Excel, Access is not quite as intuitive and you really do need some instruction to get going. This is a help forum and we are here to help you, but it is not an instructional forum.