jwcolby
jwcolby at colbyconsulting.com
Sun Nov 18 13:31:53 CST 2007
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. 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 12:23 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Outputing nulls in query with function > > I want the query to output a value computed by my function or contain > a null. Maybe this is not possible?? ========JC recommended making VBA's vbNull constant global in a module. That way you can use it in a query expression. It's a terrific idea, wish I'd thought of it. You might try that. Susan H. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com