Susan Harkins
ssharkins at gmail.com
Sun Nov 18 14:08:43 CST 2007
I think I totally misunderstand your response then. Someone was trying to use a vb constant in a query expression and I said you couldn't do that. I had always thought you couldn't use vb constants outside of a module until you responded with the global comment. Maybe I'm just confusing two different threads. If so, I apologize. Susan H. > Susan, > > No, AFAIK you cannot use any constant directly in a query, even if it is > global. you could call a function which returns a variant though.