Can anyone give me instructions or an online tutorial or whatever that
can show me how to display the results of a query in a from using variables that
For example, I’d like to have FromDate, ToDate and ClientName (variables) in the form
and the results from an already generated query be displayed in a table subform.
I guess I’d like to query the query using the above variables.
Edit: Added 2/4/18 16:30 by clendee
This is the code that I am using in the SQL command:
((UPPER(“Name”) LIKE ‘%’ || UPPER (:Var_LN) || ‘%’ ) OR (:Var_LN IS NULL))
(( “Job Date” > :Var_FromDate ) OR (:Var_FromDate IS NULL))
(( “Job Date” < :Var_ToDate ) OR (:Var_ToDate IS NULL))
The “Name” and “Job Date” are aliases in the query that I am accessing.