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

http://www.spiderwebwoman.com/resour...ks.asp#percent

--

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



gh <(E-Mail Removed)> wrote:
> 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

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)
|/----------------------------Â*-----------------------
*-----------------------------Â*-----------------------

"gh" wrote:

> 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
>