Is it possible?

[Sydious]

I have a DB that has all the employee's performance averages among other
things.

I want to make a form that would allow you to select who is working that
day, and based on the perfromance averages, calculate an expected output.

Example:
I have say 10 Combo boxes that you can select from a list of employees.
I also have a combo box that you can select the # of hours they will work.
After populating the combo boxes with the employee and the hours they work,
a text box or label or something would display the calculated expected output
based on the selected employees' performance averages.

Employee A's Performance Avg is 15 lines per hour
Employee B's Perfromance Avg is 15 lines per hour

Both Employees work for 8 hours

8 * 15 = 120 Lines per Hour

Both Emp A and B together would = 240 Lines per hour.

The text box would display 240 if I selected Emp A and Emp B.

Is this possible? or should I be going about this a diffrent way. Linking to
excel or something.

 

[Anil showreddy]

in excel you can do very much simple....

otherwise send ur specifications to (e-mail address removed) i will do in
excel and forward it for u.

 

[Steve Schapel]

Sydious,

Assuming you are talking about each employee for the day being entered
as a separate record in a continuous view form (this is probably what it
should be), then you can put an unbound textbox in the Footer section of
the form, with the Control Source set to the equivalent of this:
=Sum([Work Hours]*[Performance Avg])
(I think you meant Lines per Day in your post?)