[AccessD] Outputing nulls in query with function

Bob Heygood bheygood at abestsystems.com
Sun Nov 18 10:47:22 CST 2007


Yes, we need to do things like count and such and use TAStats. 

Thanks for replying.
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Sunday, November 18, 2007 8:34 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Outputing nulls in query with function

> I have a query that outputs a column that uses a user function to 
> create it.
> Works great.
> The client wants the results in that column to either be a value or 
> null, not an empty string or zero. We are going to do some statistical 
> jive later down the road.
> So, how can I output a null?

=======Null has a specific meaning -- forcing it might usurp that, are you
sure you really want to do that?

Susan H. 

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




More information about the AccessD mailing list