Global Variable for Query Name

[jeffatwork]

Newbie here, so be easy on me ...

How to I create a global variable (a query name) name within my reports. I have numerous reports that reference a specific query. Within those reports, I have numerous aggregate functions that reference a specific query. I'd like to create a global variable so that I can easily reference different queries just by changing a single variable.

Example:


DAvg("term","qryLease","term")
DMin("term","qryLease","term")
DMax("term","qryLease","term")

I'd like to be able to change the "qryLease" to variable.

Where do I create the variable and how do I reference that variable?


Thanks in advance

[June7]

Declare global variable as a String type in a general module. Set its value in some procedure then use it in VBA:

x = DAvg("somefield", varName, "anotherfield=somecriteria")

Global variables can only be referenced in VBA.

TempVars can be referenced in queries and ControlSource property.

Can also populate a control on form and reference that.