[AccessD] Format a field in a query for proper case

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


More information about the AccessD mailing list