Access Database Results - Format FrontPage field as currency

[Mick]

Help please!
I have the results of an Access Database Query brought out to a results
table in a FrontPage asp page. However the currency field displays on the asp
as an integer i.e.no commas to seperate the numbers.

The Database query if viewed "raw" looks ok, the field showing correctly as
currency but in Frontpage results the number displays just as an integer, any
help please would be appreciated

 

[Jim Buyens]

On page 2 of the wizard, click Custom Query and Edit, then add a computed
field such as:

SELECT Format([amount],'Currency') as fmtamount, ...

Then, report the fmtamount field instead of the amount field.

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

 

[Mick]

Jim many thanks, will have a go, regards Mick

On page 2 of the wizard, click Custom Query and Edit, then add a computed
field such as:

SELECT Format([amount],'Currency') as fmtamount, ...

Then, report the fmtamount field instead of the amount field.

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

Help please!
I have the results of an Access Database Query brought out to a results
table in a FrontPage asp page. However the currency field displays on the asp
as an integer i.e.no commas to seperate the numbers.

The Database query if viewed "raw" looks ok, the field showing correctly as
currency but in Frontpage results the number displays just as an integer, any
help please would be appreciated