DWUTKA at marlow.com
DWUTKA at marlow.com
Fri Apr 2 17:07:42 CST 2004
Good point. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart McLachlan Sent: Friday, April 02, 2004 4:57 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] ORDER BY BUG using Date format AARHG On 2 Apr 2004 at 9:45, DWUTKA at marlow.com wrote: > Because Format() returns a string, To be strictly correct, Format() returns a variant of type String. Format$() returns a string. Most of the string manipulation functions have two varieties , with and without a trailing "$". Leaving the "$" off returns a variant with the additional overhead and potential problems of using that data type. It's a good idea use the specific version wherever possible. -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com