I have a form which has two text boxes (short date fields) on it. One is named txtStart and the other txtEnd. Also on the form is a 3rd text box. I want this 3rd text box to populate with a calculated number value when the 2nd date field has been updated.
This 3rd text box, the calculated field, needs to be a DAvg calculation but the syntax has me stumped.
It needs to be something like:
MyTxtfield = DAvg (Sum of [Hours] from tblJobLabor) / (Sum of [LaborQuantity] from tblJobLabor where [LCCN] is between 15205 and 15211) where UpdateDate is between Me.txtStart and Me.txtEnd
For reference LCCN is a number field.
Can someone help?