(Msg. 1) Posted: Mon Aug 15, 2005 1:57 pm
Post subject: Frontpage results - Number rounding issue Add to elertz Archived from groups: microsoft>public>frontpage>client (more info?)
I have a Access database query that feeds my FP results page. One of the
fields is a currency format with fixed decimal places set a 2. The currency
format works correctly in access query's and reports.
My Problem is when the web page displays the the same data it truncates
trailing zeros. For example $12.90 displays as $12.9 and $126.00 displays
$126. Any ideas?
(Msg. 2) Posted: Mon Aug 15, 2005 2:36 pm
Post subject: RE: Frontpage results - Number rounding issue Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
> I have a Access database query that feeds my FP results page. One of the
> fields is a currency format with fixed decimal places set a 2. The currency
> format works correctly in access query's and reports.
>
> My Problem is when the web page displays the the same data it truncates
> trailing zeros. For example $12.90 displays as $12.9 and $126.00 displays
> $126. Any ideas?
(Msg. 3) Posted: Tue Aug 16, 2005 7:17 am
Post subject: RE: Frontpage results - Number rounding issue Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I already have the field properties set to Currency, in access the numbers
appear correctly. The problem happens when the web page displays the
numbers. Are there any settings in Frontpage for this, or a server setting
that needs changed.
"Kathleen Anderson [MVP - FrontPage]" wrote:
> http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency >
> --
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/ >
>
>
> "mccloud" wrote:
>
> > I have a Access database query that feeds my FP results page. One of the
> > fields is a currency format with fixed decimal places set a 2. The currency
> > format works correctly in access query's and reports.
> >
> > My Problem is when the web page displays the the same data it truncates
> > trailing zeros. For example $12.90 displays as $12.9 and $126.00 displays
> > $126. Any ideas?
(Msg. 4) Posted: Tue Aug 16, 2005 7:29 am
Post subject: RE: Frontpage results - Number rounding issue Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Did you read the instructions at the link I posted? It tells you how to
format the output in FrontPage.
> I already have the field properties set to Currency, in access the numbers
> appear correctly. The problem happens when the web page displays the
> numbers. Are there any settings in Frontpage for this, or a server setting
> that needs changed.
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
> > http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency > >
> > --
> > ~ Kathleen Anderson
> > Microsoft MVP - FrontPage
> > Spider Web Woman Designs
> > http://www.spiderwebwoman.com/resources/ > >
> >
> >
> > "mccloud" wrote:
> >
> > > I have a Access database query that feeds my FP results page. One of the
> > > fields is a currency format with fixed decimal places set a 2. The currency
> > > format works correctly in access query's and reports.
> > >
> > > My Problem is when the web page displays the the same data it truncates
> > > trailing zeros. For example $12.90 displays as $12.9 and $126.00 displays
> > > $126. Any ideas?
(Msg. 5) Posted: Tue Aug 16, 2005 7:49 am
Post subject: RE: Frontpage results - Number rounding issue Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Worked!
Thanks
"Kathleen Anderson [MVP - FrontPage]" wrote:
> Did you read the instructions at the link I posted? It tells you how to
> format the output in FrontPage.
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/ >
>
>
> "mccloud" wrote:
>
> > I already have the field properties set to Currency, in access the numbers
> > appear correctly. The problem happens when the web page displays the
> > numbers. Are there any settings in Frontpage for this, or a server setting
> > that needs changed.
> >
> > "Kathleen Anderson [MVP - FrontPage]" wrote:
> >
> > > http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency > > >
> > > --
> > > ~ Kathleen Anderson
> > > Microsoft MVP - FrontPage
> > > Spider Web Woman Designs
> > > http://www.spiderwebwoman.com/resources/ > > >
> > >
> > >
> > > "mccloud" wrote:
> > >
> > > > I have a Access database query that feeds my FP results page. One of the
> > > > fields is a currency format with fixed decimal places set a 2. The currency
> > > > format works correctly in access query's and reports.
> > > >
> > > > My Problem is when the web page displays the the same data it truncates
> > > > trailing zeros. For example $12.90 displays as $12.9 and $126.00 displays
> > > > $126. Any ideas?
(Msg. 6) Posted: Mon Jun 19, 2006 1:25 pm
Post subject: RE: Frontpage results - Number rounding issue Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Kathleen sorry if this is a dead thread, but its just what I need. I have
read the Spiderwebwoman tips and seen the code to be inserted into the SQL,
but please where does it go in the SQL part of the page, I dont quite
understand this bit.Secondly, does inserting this code give you a new field
name that you should pick up somewhere please. (I actually need to format
percentages but it looks like the same princiles to apply? It aall looks ok
in the Access Query feeding the ASP, 2 decimal places, but the ASP shows it
to about 8 or more) Thanks Mick
"Kathleen Anderson [MVP - FrontPage]" wrote:
> Did you read the instructions at the link I posted? It tells you how to
> format the output in FrontPage.
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/ >
>
>
> "mccloud" wrote:
>
> > I already have the field properties set to Currency, in access the numbers
> > appear correctly. The problem happens when the web page displays the
> > numbers. Are there any settings in Frontpage for this, or a server setting
> > that needs changed.
> >
> > "Kathleen Anderson [MVP - FrontPage]" wrote:
> >
> > > http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency > > >
> > > --
> > > ~ Kathleen Anderson
> > > Microsoft MVP - FrontPage
> > > Spider Web Woman Designs
> > > http://www.spiderwebwoman.com/resources/ > > >
> > >
> > >
> > > "mccloud" wrote:
> > >
> > > > I have a Access database query that feeds my FP results page. One of the
> > > > fields is a currency format with fixed decimal places set a 2. The currency
> > > > format works correctly in access query's and reports.
> > > >
> > > > My Problem is when the web page displays the the same data it truncates
> > > > trailing zeros. For example $12.90 displays as $12.9 and $126.00 displays
> > > > $126. Any ideas?
(Msg. 7) Posted: Mon Jun 19, 2006 5:39 pm
Post subject: Re: Frontpage results - Number rounding issue Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Mick:
Here's one way to do it: rerun the Database Wizard and modify the SQL in the
Custom Query window. Let FrontPage (re)generate the page, and the new field
should show up on the page.
"Mick" <Mick.TakeThisOut@discussions.microsoft.com> wrote in message
news:C0ACBC1D-7F0B-4971-882E-E25A07ABFDC1@microsoft.com...
> Kathleen sorry if this is a dead thread, but its just what I need. I have
> read the Spiderwebwoman tips and seen the code to be inserted into the
> SQL,
> but please where does it go in the SQL part of the page, I dont quite
> understand this bit.Secondly, does inserting this code give you a new
> field
> name that you should pick up somewhere please. (I actually need to format
> percentages but it looks like the same princiles to apply? It aall looks
> ok
> in the Access Query feeding the ASP, 2 decimal places, but the ASP shows
> it
> to about 8 or more) Thanks Mick
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
>> Did you read the instructions at the link I posted? It tells you how to
>> format the output in FrontPage.
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> http://www.spiderwebwoman.com/resources/ >>
>>
>>
>> "mccloud" wrote:
>>
>> > I already have the field properties set to Currency, in access the
>> > numbers
>> > appear correctly. The problem happens when the web page displays the
>> > numbers. Are there any settings in Frontpage for this, or a server
>> > setting
>> > that needs changed.
>> >
>> > "Kathleen Anderson [MVP - FrontPage]" wrote:
>> >
>> > > http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency >> > >
>> > > --
>> > > ~ Kathleen Anderson
>> > > Microsoft MVP - FrontPage
>> > > Spider Web Woman Designs
>> > > http://www.spiderwebwoman.com/resources/ >> > >
>> > >
>> > >
>> > > "mccloud" wrote:
>> > >
>> > > > I have a Access database query that feeds my FP results page. One
>> > > > of the
>> > > > fields is a currency format with fixed decimal places set a 2. The
>> > > > currency
>> > > > format works correctly in access query's and reports.
>> > > >
>> > > > My Problem is when the web page displays the the same data it
>> > > > truncates
>> > > > trailing zeros. For example $12.90 displays as $12.9 and $126.00
>> > > > displays
>> > > > $126. Any ideas?
(Msg. 8) Posted: Wed Jun 21, 2006 4:00 am
Post subject: Re: Frontpage results - Number rounding issue Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Kathleen, thanks for the reply, Im stilll not qite there Im afraid.
I opened the "Custom Query" and added the second line thus:
SELECT * FROM clientswherefind
Format(Expr1,'##0.00##%') as newPercent
Expr1 is a calculated percentage field in a Access Database within query
"clientswherefind", however it gives me reselts to 10 or more decimal places
on the ASP.
Unfortunately t errors immediately, am I missing something between the two
parts of the query please.
Kind regards
Mick
"Kathleen Anderson [MVP - FrontPage]" wrote:
> Hi Mick:
> Here's one way to do it: rerun the Database Wizard and modify the SQL in the
> Custom Query window. Let FrontPage (re)generate the page, and the new field
> should show up on the page.
>
> Also, here's how to format the field as a percentage:
> http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#percent >
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/ >
>
> "Mick" <Mick.DeleteThis@discussions.microsoft.com> wrote in message
> news:C0ACBC1D-7F0B-4971-882E-E25A07ABFDC1@microsoft.com...
> > Kathleen sorry if this is a dead thread, but its just what I need. I have
> > read the Spiderwebwoman tips and seen the code to be inserted into the
> > SQL,
> > but please where does it go in the SQL part of the page, I dont quite
> > understand this bit.Secondly, does inserting this code give you a new
> > field
> > name that you should pick up somewhere please. (I actually need to format
> > percentages but it looks like the same princiles to apply? It aall looks
> > ok
> > in the Access Query feeding the ASP, 2 decimal places, but the ASP shows
> > it
> > to about 8 or more) Thanks Mick
> >
> > "Kathleen Anderson [MVP - FrontPage]" wrote:
> >
> >> Did you read the instructions at the link I posted? It tells you how to
> >> format the output in FrontPage.
> >>
> >> --
> >>
> >> ~ Kathleen Anderson
> >> Microsoft MVP - FrontPage
> >> Spider Web Woman Designs
> >> http://www.spiderwebwoman.com/resources/ > >>
> >>
> >>
> >> "mccloud" wrote:
> >>
> >> > I already have the field properties set to Currency, in access the
> >> > numbers
> >> > appear correctly. The problem happens when the web page displays the
> >> > numbers. Are there any settings in Frontpage for this, or a server
> >> > setting
> >> > that needs changed.
> >> >
> >> > "Kathleen Anderson [MVP - FrontPage]" wrote:
> >> >
> >> > > http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency > >> > >
> >> > > --
> >> > > ~ Kathleen Anderson
> >> > > Microsoft MVP - FrontPage
> >> > > Spider Web Woman Designs
> >> > > http://www.spiderwebwoman.com/resources/ > >> > >
> >> > >
> >> > >
> >> > > "mccloud" wrote:
> >> > >
> >> > > > I have a Access database query that feeds my FP results page. One
> >> > > > of the
> >> > > > fields is a currency format with fixed decimal places set a 2. The
> >> > > > currency
> >> > > > format works correctly in access query's and reports.
> >> > > >
> >> > > > My Problem is when the web page displays the the same data it
> >> > > > truncates
> >> > > > trailing zeros. For example $12.90 displays as $12.9 and $126.00
> >> > > > displays
> >> > > > $126. Any ideas?
>
>
>
All times are: Eastern Time (US & Canada) (change) Goto page 1, 2, 3
Page 1 of 3
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office Other