In a table I have a date/time field that looks like this for example:
4/16/2014 12:43:41 PM
But I want to query records using just the date part of that information.
My query criteria looks like:
Between [Forms]![frmSelectDatesForLaborTranxReport]![txtStart] And [Forms]![frmSelectDatesForLaborTranxReport]![txtEnd]
But I 'm sure I have to change it somehow to return the records that have 4/16/2014 or whatever date range is entered in frmSelectDatesForLaborTranxReport
How can I do this?