Yes, I get prompted if I attempt to open the query alone. The query is invoked on Open, set in the Event properties of the report but I don't think it is working correctly.
Here is the SQL from the query.
SELECT Call_Detail.Date
FROM Call_Detail
WHERE (((Call_Detail.Date) Between [Enter Start...
I have a report that I need to be able to define a date range. I have created a query and used the criteria
Between [Enter Start Date] and [Enter end Date]
but when I run the query the report still pulls all records. What am I missing here? Thanks in advance.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.