DCount Expression needed for Formual?

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

I have a main form with 2 sub-forms on it that is used to calculate the
amounto Invoice a customer.
Here is my dilemna; The below code works OK with the exception of that it
DOES NOT account for more than 1 employee.
it works if there are 2 or more employees.

#1 thru 3 are all on the main form.Text Boxes that is

#1 gets it's value from the Time and Hours sub-form plus 2 other text boxes
on the main form
#2 "" " the Vendor List sub-form Times 1.3
#3 "" " Text box Amount on the main form Plus
Text330 Divided by 2

The DCount needs to come from the Time and Hours form where it uses
EmployeeID from the Employees table
In other words, if there less than 2 employee's on the Time and Hours
sub-form, then the formula needs to double.
i.e. #3 (Amount to Invoice) Text331=Nz([Amount]+[Text330],0)

How can I do this?


1.(Employee Time) Text330==NZ([Time and
Hours].[Form]![Text95]*[Text500]+[Text501],0)
2.(Material Amount) Amount==Nz([Vendor List].Form!Text18*1.3,0)
3.(Amount to Invoice) Text331==Nz([Amount]+[Text330],0)/2
 
Added Code: #4 (Text511)=[Time and Hours].[Form]![Text110] on main form,
this shows the count of employees on the sub-form Time and Hours, so now all
I have to do is figure out how to add this to my formula for Textbox331 and
else it show the default of formula as it is right now. Any Suggestions as
to how to do this?
In other words again, if the count of employees is over 1 then Text331 is
==Nz([Amount]+[Text330],0)/2
else; ==Nz([Amount]+[Text330],0)
 
Back
Top