Calculated expressions problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all, there is basically a Timesheet form where i have :

- a Rate per Hour field (which is a lookup column with different rates per
hour (5,6,7,8,) etc,
- Total Hours : calculated using (=TimesheetSubform.Form!SummedHoursMinutes)
- this references the timesheet subform and has a format of 0:00

I created a Payment field called Total Amount Payable (the textbox is called
Total), whereby i want to multiply the rate per hour by the total hours
=[Total]*[Rate per hr] but this comes up with an #error. Does anyone know why
this is?
 
Connie said:
Hi all, there is basically a Timesheet form where i have :

- a Rate per Hour field (which is a lookup column with different rates per
hour (5,6,7,8,) etc,
- Total Hours : calculated using (=TimesheetSubform.Form!SummedHoursMinutes)
- this references the timesheet subform and has a format of 0:00

I created a Payment field called Total Amount Payable (the textbox is called
Total), whereby i want to multiply the rate per hour by the total hours
=[Total]*[Rate per hr] but this comes up with an #error. Does anyone know why
this is?
Click to expand...


As long as the total in the subform is working ok, the
problem is that the total text box's expression refers to
itself. Don't you really want the total text box's
expression to be:
=TimesheetSubform.Form!SummedHoursMinutes*[Rate per hr]

If the expression really need to refer to a record source
field named Total, then change the name of the text box to
something other than Total (e.g. txtTotal).
 
Back
Top