Dave,

I am not really able to answer that question, on the basis of the
information I have at present.  But here's the concept... Think about
the table or query that is the Record Source of the EmpCalc form.  Ok,
which field(s) need to have a criteria applied in order for you to
obtain the records you require?  Ok, which form(s) have data in the
current record which will determine these criteria?  Ok, so that's what
you have to use.  As I mentioned before, the syntax of your code will
also depend on the where the code is being called from, which only you know.

How can I make the form (EmpCalc) ONLY show the same records as the form
Time and Hours located on my main form TimeCards?
Both Time and Hours and EmpCalc have the same recordsource, that is they use
the same query.
Tried the bellow code for the EmpCalc form on the load event, ALL records
showed.

Set Me.Form.Recordset = Forms("Time and Hours").Form.Recordset

Form: EmpCalc
6 fields
EmployeeID: shows the employee
TimeCounter: shows the invoice number
work date: shows the date the employee worked
Text34  =Format([Work Date],"dddd")  shows the work date in day format
hours:  shows the hours worked for each employee
overtime: shows the overtime worked for each employee
Both fields below are located in the form footer...........................
Text95:  shows the total hours for all employees;=Sum([Hours])
SumOfoVERTIME: SHOWS the total overtime for all employees;=Sum([Overtime])

The idea is too count how many days where there are more than 2 employees
who worked on the same job,i.e. TimeCounter (Invoice Number) of course the
regular rate for 2 or less
employees still counts as well and has to be figured in.
this is necessary because the rate changes at which the customer is billed
when the count of employees
is more than 2 on any given day. For one or two employees the rate 65.00 a
hour, for each employee after
that the rate becomes 1/2 the rate added to the original rate (32.50). Now
the rate becomes 97.50 for each hour
that 3 employees worked on for the same day.so the calculation gets
complicated for me as you can see.
Example: Forest Gump works on Monday 05/30/05 as well as Bubba Gump and
Billy Bob and the total hours worked
is 24. Then the customer will be billed for 24 hours @ 97.50 AN HOUR.
If on Tuseday for the same Invoice Number, i.e. TimeCounter only 2 employees
worked 8 hours each, then the rate of 65.00 a
hour will be used to calculate at 16 hours * 65.00. this will be added to
the existing time for Monday and the
final total will be billed to the customer.

So the calculation must be performed for each day;
Lost as to how to proceed!
I have the data on the form, just need to sort it out so it can be
calculated.

Thanks,

Dave