I have a query that uses a criteria that looks like 'Between [enter beginning date] And [enter ending Date]". if I enter the beginning date of 6/01/2016 and the end date of 6/02/2016 it will show all records for 6/1/2016. I would like to reduce the amount of key strokes for the user by changing the criteria to only input the actual day date needed. So I would like to enter 6/01/2016 only and receive all records for that date.
The problem is the field includes date and time. Everything I have tried has returned zero records. Is there a way to enter a wildcard like 6/01/2016*?
What are my options?
Thanks
Rick