If the selected function in the Functions option on the Fields tab allows specifying variables, then users must inform the value of those variables on the Variables tab or by using Query's SetVariableValue method at run time, according to the next example.

Set Chart = Screen.Item("E3Chart1")
Set Query = Chart.Item("Query1")
Query.SetVariableValue "StartTime", Chart.IniDate
Query.SetVariableValue "EndTime", Chart.EndDate
Query.SetVariableValue "TimeInterval",_
  rs.Fields("SampleInterval").Value
Chart.Queries.UpdateData()

In addition to variables, users can also define a specific filter for each column returned by a Query on the Filter column of the Fields tab. To specify, for example, that a certain column must return only values greater than or equal to 1 (one) and less than 5 (five), fill in the Filter column with the expression ">= 1 and < 5".