Dear All
I have a query to find clients between a date range for the date quotes were sent.
Currently when I run the query I have to enter a date past my target date to get the right results!
I use a between dates criteria and want to find all the records sent on say the 19 Jan 2011. I would have to enter, start date: 19-01-1 & end date 20-01-11 to find all the quotes sent on the 19th. I there a way to to enter the date I want and not have to enter a day past each time:
I use this criteria [Type Start Date] And [Type End Date]
Thanks Mark
I have a query to find clients between a date range for the date quotes were sent.
Currently when I run the query I have to enter a date past my target date to get the right results!
I use a between dates criteria and want to find all the records sent on say the 19 Jan 2011. I would have to enter, start date: 19-01-1 & end date 20-01-11 to find all the quotes sent on the 19th. I there a way to to enter the date I want and not have to enter a day past each time:
I use this criteria [Type Start Date] And [Type End Date]
Thanks Mark
