On a report I am trying to use VBA code to sum hours on a text field in the onprint event of the report.
Here is what I'm attempting to write:
Me.txtGrp1RegHrs = DSum("RegHrs", "tblTimeCardTranxDetail", "tblTimeCardTranxHeader.TranxDate" is between Forms!frmSelectDatesForHRreport.txtStart and Forms!frmSelectDatesForHRreport.txtEnd
Note that the criteria uses a separate table.field. Also, I know this syntax is wrong.
Can this be done?