Formatting number - database results properties

[Jay Anderson]

Using the database results feature, a simple query returns
a number. How do I make 10000 display as 10,000, for
example? I am counting data stored in SQL Server 7. Thanks.

 

[Kathleen Anderson [MVP - FP]]

In your SQL, Format(myNumber,'###,##0') as newNumber

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/