Decimal space problem with FP insert database

[john elfrank]

When I insert a database and link to an Excel file in the
fpdb folder, calculated fields show several decimal
spaces. Even though I have the decminal spaces under
control in Excel, they come out on the front page results
page.

Is there any way of controling this so there are no
decimal spaces in the calculated fields of my linked
Excel file?

Thanks in advance,

John

John Elfrank-Dana
Social Studies Teacher/Web Master
Murry Bergtraum High School
(e-mail address removed)
http://www.elfrank.org

 

[Jim Buyens]

Sadly, the database results wizard has no built-in
facility for formatting numeric fields.

The alternative is to specify a custom query that does the
formatting you want within the SQL statement. Here's an
example:

SELECT Format([dollaramt],"#,##0") As damount, ...

You would then configure the DRW to display the calculated
damount field.

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

 

[john elfrank-dana]

Bummer. Thanks!

-----Original Message-----
Sadly, the database results wizard has no built-in
facility for formatting numeric fields.

The alternative is to specify a custom query that does the
formatting you want within the SQL statement. Here's an
example:

SELECT Format([dollaramt],"#,##0") As damount, ...

You would then configure the DRW to display the calculated
damount field.

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

-----Original Message-----
When I insert a database and link to an Excel file in the
fpdb folder, calculated fields show several decimal
spaces. Even though I have the decminal spaces under
control in Excel, they come out on the front page results
page.

Is there any way of controling this so there are no
decimal spaces in the calculated fields of my linked
Excel file?

Thanks in advance,

John

John Elfrank-Dana
Social Studies Teacher/Web Master
Murry Bergtraum High School
(e-mail address removed)
http://www.elfrank.org
.

.