I'm currently working towards a report for a database I put together. I've created a simple query with all the relevant values from the main table; since I want to be able to filter by date, I've added the following to the criteria field for SubmissionDate: "Between [Enter start date:] And [Enter end date:]".
This works fine the first time I run the query, but if I run it a second time and enter new values (or even the same ones), I keep getting asked to enter the start date and end date. I never actually get to the datasheet. If I click on "Cancel" instead, I get an empty list.
Any idea what might be the issue here? It seems pretty darn strange to me - but then I haven't really worked with query parameters in a long time.
This works fine the first time I run the query, but if I run it a second time and enter new values (or even the same ones), I keep getting asked to enter the start date and end date. I never actually get to the datasheet. If I click on "Cancel" instead, I get an empty list.
Any idea what might be the issue here? It seems pretty darn strange to me - but then I haven't really worked with query parameters in a long time.
