Access querry

  • Thread starter Thread starter Belcredit
  • Start date Start date
How do I tell the querry that my criteria is in the value of a global verable
Click to expand...

You can't, as stated. The JET database engine has no knowledge of VBA
constants or variables.

You'll need to create a dumb little function, GetVal, like

Public Function GetVal()
GetVal = glbMyGlobalVariable
End Function

and use

=GetVal()

as the criterion in your query.

John W. Vinson [MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text to time conversion 3
Using Wild Cards in Paramter Querry 2
Parameter Querries and Wildcards 4
Querry Criteria 4
Subject: Need help on Iff Statement 1
Union Querry 1
three query union. 13
review sql querry 2

Back
Top