Page 1 of 1

Parameterized report help

Posted: Wed Sep 06, 2017 10:37 am
by drk
I am trying to generate a report where the user enters a random date and it is matched to "Date Created" or "Date Modified" in the Transactions table. Using the built-in query designer, I can have the user enter the date twice during report generation. I would like the user to pick the date only once, and have that date matched to other dates in the Transactions Table.

Stated differently, how do I go about building a parameterized query where the parameter is not a field in the database? That is, gather user input for a new variable and use that to match specific fields in the database at run-time?