How do I tell the querry that my criteria is in the value of a global verable
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]
