Aaron -
Try this:
Format$(field1,",#.##") + chr$(13) + Format$(field2",#.##")
if both field 1 and 2 are numbers you wish to show with a comma.
The expression (field1,",#.##") means to take field1 and display it with a
comma as the thousands separator and 2 decimal places. If no decimals are
required, use ",#" instead.
Cheers,
Lindsay Giles
Senior GIS Analyst
AXYS Environmental Consulting Ltd
Suite 600-555 4th Ave. SW
Calgary, AB
T2P 3E7
e-mail: [EMAIL PROTECTED]
Main Office: 403-269-5150
Direct Line: 403-750-7671
Fax: 403-269-5245
Visit our web site at http://www.axys.net
-----Original Message-----
From: Aaron Queheillalt [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, June 13, 2000 12:31 PM
To: 'MapInfo-L'
Subject: MI label expression dropping commas
I was wondering if anyone had any ideas on this one.
I am creating labels with an expression to show several fields of
information. When I label with one field the numbers are shown with a
comma, such as 230,000. When I create an expression
(field1+chr$(13)+field2), the numbers shown do not have the comma. Some of
the numbers are very large and a comma is desired. I have tried changing
the field type from Integer to Float and as a character without any luck.
I
would rather not double-click on each label and add comma's to each one.
Thanks, any ideas would be greatly appreciated
Aaron Queheillalt
Visual/Mapping Analyst
The Sacramento Bee
916-321-1596
<< File: ATT00008.htm >>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
