[AccessD] Outputing nulls in query with function

I think I was confused.  I thought you were asking about "seeing" a constant
outside of a module, not specifically in a query. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Sunday, November 18, 2007 3:09 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Outputing nulls in query with function

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.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com