D
Dave Elliott
I have a main form named TimeCards with a field named Rate on it that is in
currency format
It's purpose is to set the customers default rate at which to be charged for
each employee on the job
Also on the main form is a sub-form named Time and Hours where the employee
hours, pay rate , work date, etc...
are used to calculate the hours times the Rate to Invoice the customer as
well as used to pay the employee.
there is a field named Employee Time with it's control source set to
EmployeeID
this shows a list of all employees and it's control source for the form is
query Time_Hours
also a field named Hours that is used to count the employees hours worked on
the job.
Here is where I need help.
If the count of employee(s) is less than 2 and the hours is less than 2,
then I need to change the Rate on the main form to 65 or else 55 depending
on the other field that is linked to the customers table named Text430
=[NameB].[Column](10)/2
this code is the customers default rate divided by 2 and is looked up when a
customer is chosen for the form.
If however the customers rate is 55, which is a preferred rate then the Rate
needs to be 55 with the same criteria as above.
Rate on the main form is set to the default of =[Text430]
It also warns if the amounts do not match, i.e. Text430 and Rate
How can I do this?
Thanks,
Dave
currency format
It's purpose is to set the customers default rate at which to be charged for
each employee on the job
Also on the main form is a sub-form named Time and Hours where the employee
hours, pay rate , work date, etc...
are used to calculate the hours times the Rate to Invoice the customer as
well as used to pay the employee.
there is a field named Employee Time with it's control source set to
EmployeeID
this shows a list of all employees and it's control source for the form is
query Time_Hours
also a field named Hours that is used to count the employees hours worked on
the job.
Here is where I need help.
If the count of employee(s) is less than 2 and the hours is less than 2,
then I need to change the Rate on the main form to 65 or else 55 depending
on the other field that is linked to the customers table named Text430
=[NameB].[Column](10)/2
this code is the customers default rate divided by 2 and is looked up when a
customer is chosen for the form.
If however the customers rate is 55, which is a preferred rate then the Rate
needs to be 55 with the same criteria as above.
Rate on the main form is set to the default of =[Text430]
It also warns if the amounts do not match, i.e. Text430 and Rate
How can I do this?
Thanks,
Dave