decimal places in database results wizard

[Guest]

database results wizard is displaying 15 digit results(0.666666666666667
for example), how can i get it to display only 2. The field is a percentage
yes based on total yes/no reponses

 

[Kathleen Anderson [MVP - FrontPage]]

http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#percent

--

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

 

[Guest]

Use a custom query that includes a computed field such as:

Format([MyPctField],"Percent") AS FmtPct

and then report the FmtPct field rather than the MyPctField field.

If you're already using a custom query that uses SUM and GROUP BY clauses to
compute the percents, this may be more complicated. In that case, you might
want to post your existing SQL statement.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------­-----------------------
|\----------------------------­-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------­-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------­-----------------------
*-----------------------------­-----------------------