Criteria=Global Vairable

[benc]

How can i set the criteria to of a query to be the value of a global variable i have created. THanks

 

[Fornatian]

Use a function to return the value of the variable, you cannot directly reference it.

Function fnGetMyVariable() as String 'assume its a string
fnGetMyVariable = gVariable
End function.

Call the function as the criteria

 

[Pat Hartman]

Continuing the example posted by Fornatian,

Select *
From YourTable Where SomeField = fnGetMyVariable();

 

[benc]

HOw can i insert the function a query, i can see any command to be able to do that.

 

[Rich]

Use the Code builder to reference the Function

 

[benc]

Im sorry and i dont want to waste your time or sound stupid but i went into the design view of the query and could not see 'code builder'. I have a report that picks up the data from that query and therefore need to put the function in the query. Unless someone can think of a better idea for it. THanks

 

[Jon K]

Switch to SQL View of the query and type the function in the Where clause as Pat has shown.

 

[Fornatian]

..or right click in the criteria row and select 'build', then in the expression builder choose functions-'name of your db' and the your functions will be listed on the right -double click to insert into the function fnGetMyVariable into the text box and OK. Your function doesn't require any arguments so job's a good 'un as we say up north.