decimal places in database results wizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
|/----------------------------­-----------------------
*-----------------------------­-----------------------
 
Back
Top