calculations of total time assigned to person

[Guest]

I have a scheduling form where in the main form I have Date,
Personnel(listbox), and joblocnumer(combobox) and what is picked in the list
and combo box schedule and assigned people to do given jobs for a given day.
- this is displayed in the subform. I would like to be able to assign the
jobs and see how many total hours PER PERSON is assigned - so I don't over
schedule someone.

Not sure how and where to do this calculation???? since need it by
PersonnelIdnum

Thanks,
Barb

 

[jahoobob via AccessMonster.com]

You can do it one of two ways:
1)Schedule each person from a start time to an end time for each job or
2)Assign each person certain hours for each job.
I believe the best way to do this is to have a single form to select the
person and enter the date and have a continuous subform in this form to enter
the scheduled jobs for the day linked by the PersonnelID number.
I assume you already have a table of Personnel and a table of Jobs. You will
need another table of ScheduledJobs.
When you do this, you can select a person form the listbox and put in the
date then move to the subform and assign each job via the combobox and a
start time and an end time.
BTW, create a query based on the ScheduledJobs table that will calculate the
difference between begining time and ending time. You can then place a sum
of this new query field in the header of the subform and see the total time
assigned per person.
Hope this helps.
Bob

 

[Guest]

My main and subform are set up differently than what you are explaining and I
need it that way so that I can get rid of job already assigned from the combo
dropdownlist of main form.


The main form is based on ONE Day (that is the field linked to the subform)
and the listbox of personnel and combo box of jobs - by selecting these items
it Schedules them in the subform for that day. So many different people are
listed in the subform - but still would like to calculated BY person their
calculated time of jobs assigned to them. the est. time is available in the
subform as a field per job that was assigned to them.

Can't figure out how to get this calc.

thanks,
barb

 

[Pete]

In the Master form you can calculate the hours of the individual record
selected in the subform. A little query on that selected persons records
using One Day and persons name field as your criteria to get the total hours
simply sum it together. Have the subform when selected requery and place
text box on the main to hold the total. You can also use Dsum as a textbox
control source on the form see below.
http://www.utteraccess.com/forums/showflat.php?Board=83&Number=1449591
or
Sum Subform
http://www.databasedev.co.uk/subform-total.html

 

[Guest]

There are multiple records for one employee in the subform. the main form is
based on onerecord for one day and the subform list the first and last name
and who is assigned what cleaning job for the day with the est. cleaning
time. Just want to get a running total PER employee so don't overassign.

Any ideas?
Thanks so much for helping,
Barb

 

[Guest]

I would like to make the main form based off of each employee and do what you
suggested - just not sure how to make sure I do not schedule the same job at
a given loc(list from joblocautonum - table) not more than ONE Time- any
idea?????

Thanks,
barb