Can I create a query that uses data pulled from specific cells in Calc as the user input for a query?
I have a query that I built in the Query Designer that requests a start and dates from the user using >= :StartDate and <= :EndDate. I would prefer to be able to grab the start and end dates from cells on a Calc worksheet.
Now that I have a working query I open a new Calc workbook, View > Data Sources and then I drop the above query into Calc. Works great but I still have to manually enter the start and end dates for the query from the pop up box.
Maybe my method is flawed but I haven’t been able to find any other methods for getting user entered parameters into a query.
This is the section of my query that’s getting the user input:
`TRANSACTIONS`.`transaction_date` >= :StartDate AND `TRANSACTIONS`.`transaction_date` <= :EndDate ORDER BY `TRANSACTIONS`.`transaction_date` ASC