Do more with
WHERE DateValue(tblClaims.InvoiceSentDate) >= cdate([Forms]![form1]![text63])
AND DateValue(tblClaims.InvoiceSentDate) <= cdate([Forms]![form1]![text65])
This assumes you have other code that would require that text63 and text65 contain values. Otherwise, you might want to use the NZ() function to force dates into those criteria.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial