Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Sun Nov 2 16:06:51 CST 2008
How different? And how come? Wouldn't NZ(Class,9999) sort the nulls to the bottom? Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel Sent: Sunday, November 02, 2008 1:45 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Sort Blanks to the bottom Begging your pardon, Rocky, but this will give a different result from what you are now using. Regards Steve Rocky Smolin at Beach Access Software wrote: > That would work, too. You think evaluating Nz or iif is faster? -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com