Klos, Susan
Susan.Klos at fldoe.org
Sun Jun 15 18:36:55 CDT 2003
That worked great. Thanks. -----Original Message----- From: Steve Goodhall [mailto:sgoodhall at comcast.net] Sent: Sunday, June 15, 2003 2:41 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Format a field in a query for proper case I ran this through my test bed and it works. SELECT StrConv([Table1]![T1Text],3) AS Expr1 FROM Table1; Table1 contents T1ID T1Text 1 ALL UPPER 2 all lower 3 Already Proper 4 iNVERSE cASE Query Output Expr1 All Upper All Lower Already Proper Inverse Case Regards, Steve Goodhall -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Klos, Susan Sent: Sunday, June 15, 2003 2:07 PM To: 'accessd at databaseadvisors.com' Subject: [AccessD] Format a field in a query for proper case I guess the subject tells it all. I have a query that contains school names which are almost all upper case. I would like to set them to proper case in the query. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com