<div>
<div class="content wysiwyg-content">
On a report I am trying to use VBA code to sum hours on a text field in the onprint event of the report. &nbsp;<br />
<br />
Here is what I'm attempting to write:<br />
<br />
Me.txtGrp1RegHrs = DSum(&quot;RegHrs&quot;, &quot;tblTimeCardTranxDetail&quot;, &quot;tblTimeCardTranxHeader.Tr<wbr />anxDate&quot; is between Forms!frmSelectDatesForHRr<wbr />eport.txtS<wbr />tart and Forms!frmSelectDatesForHRr<wbr />eport.txtE<wbr />nd<br />
<br />
Note that the criteria uses a separate table.field. &nbsp;Also, I know this syntax is wrong.<br />
<br />
Can this be done?
</div>
</div>


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?

DSum values problem

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.