This is Interesting: Free Magazines for Graphics designers and webmasters
Home > Archive > Front Page > January 2005 > Access Database Results - Format FrontPage field as currency
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Access Database Results - Format FrontPage field as currency
|
|
|
| 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 2005-01-31, 1:07 pm |
| 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" wrote:
> 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 many thanks, will have a go, regards Mick
"Jim Buyens" wrote:
[color=darkred]
> 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" wrote:
>
|
|
|
| | Copyright 2003 - 2008 forum4designers.com Software forum Computer Hardware reviews |
|