Calculated expressions problem

[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?

 

[Marshall Barton]

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?

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).