General information about Medisoft
- Posts: 155
- Joined: Sat Oct 11, 2014 11:40 am
- Location: Boston, MA
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?