Global Variables

[Guest]

Is there a way to use global variables in reports and queries?

 

[Ken Snell [MVP]]

In a report, you can refer to the variable by name.

In a query, you must call a public function that returns the value of the
variable:
Public Function GetVariableOne()
GetVariableOne = NameOfYourVariable
End Function