Format the result from an Access Database Query

[Guest]

Help please!
I have the results of an Access Database Query brought out to a results
table in a FrontPage asp page. The number field displayed on the asp page (in
a table) is an integer i.e.no commas to seperate the numbers and hence
difficult to read.

I have tried various settings in Access but none seems to influence the
output on the .asp page. I know (from another post) that this problem
possibly can be fixed with a custom query from within Frontpage but my query
in Access is very complex hence another workaround would be nice. Any
suggestions?

 

[Kathleen Anderson]

http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency
(leave off the dollar sign)

--

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