Create a public function (in a regular module) that reads the value of the
variable -- note that the variable must be a global variable:

Public Function GetMyVariable()
GetMyVariable = NameOfTheVariable
End Function

Then call the function in your query using GetMyVariable().