How can I limit a dcount expression date range to a specific EndDate time (ie 8:00:00AM)?
Example form inputs:
txtStartDate = 10/16/2009 6:00:00 AM
txtEndDate = 10/16/2009 5:00:00 PM
Current report field (dcounts the entire datetime range above):
=DCount("[Order Number]","qryTotal_Orders","[Order Date] Between #" & [Forms]![frmShipments]![txtStartDate] & "# And #" & [Forms]![frmShipments]![txtEndDate] & "#")
I would like to create a second report field using the same dcount expression, but only dcount until the txtEndDate of 8:00:00 AM no matter what time was actually was entered. What syntax do I need to add to a copy of the above dcount expression?