(Msg. 9) Posted: Wed Jun 21, 2006 11:29 am
Post subject: Re: Frontpage results - Number rounding issue [Login to view extended thread Info.] Archived from groups: microsoft>public>frontpage>client (more info?)
If you are using an Access Query as your DRW Recordsource (as a 'View'), you
can't modify the SQL, as far as I know. Can you copy the Access Query SQL
into the Custom Query window of a new DRW and change it there?
"Mick" <Mick.TakeThisOut@discussions.microsoft.com> wrote in message
news:26581493-DF4B-44FC-8031-ABB8580F4D84@microsoft.com...
> 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.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. 10) Posted: Mon Jun 30, 2008 6:59 am
Post subject: Re: Frontpage results - Number rounding issue [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Kathleen,
I am having the same problem as well, I'm using a query to extract results
that I need to show in percentages correctly!
I created them in Front Page however, I also have Expression Web, any chance
I can get the results to show correctly using EP? I've tried to find it
myself but so far I've had no luck in finding a solution to this anywhere.
Your help is greatly appreciated.
"Kathleen Anderson [MVP - FrontPage]" wrote:
> If you are using an Access Query as your DRW Recordsource (as a 'View'), you
> can't modify the SQL, as far as I know. Can you copy the Access Query SQL
> into the Custom Query window of a new DRW and change it there?
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/ > FrontPage Support: http://www.frontpagemvps.com/ >
>
>
>
> "Mick" <Mick RemoveThis @discussions.microsoft.com> wrote in message
> news:26581493-DF4B-44FC-8031-ABB8580F4D84@microsoft.com...
> > 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 RemoveThis @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. 11) Posted: Mon Jun 30, 2008 7:16 pm
Post subject: Re: Frontpage results - Number rounding issue [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"Syn1962" <Syn1962.DeleteThis@discussions.microsoft.com> wrote in message
news:8E784FC2-0A47-44D1-9158-6EAD25D5577A@microsoft.com...
> Kathleen,
> I am having the same problem as well, I'm using a query to extract results
> that I need to show in percentages correctly!
> I created them in Front Page however, I also have Expression Web, any
> chance
> I can get the results to show correctly using EP? I've tried to find it
> myself but so far I've had no luck in finding a solution to this anywhere.
>
> Your help is greatly appreciated.
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
>> If you are using an Access Query as your DRW Recordsource (as a 'View'),
>> you
>> can't modify the SQL, as far as I know. Can you copy the Access Query SQL
>> into the Custom Query window of a new DRW and change it there?
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> web: http://www.spiderwebwoman.com/resources/ >> FrontPage Support: http://www.frontpagemvps.com/ >>
>>
>>
>>
>> "Mick" <Mick.DeleteThis@discussions.microsoft.com> wrote in message
>> news:26581493-DF4B-44FC-8031-ABB8580F4D84@microsoft.com...
>> > 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?
>> >>
>> >>
>> >>
>>
>>
>>
(Msg. 12) Posted: Thu Jul 03, 2008 7:48 am
Post subject: Re: Frontpage results - Number rounding issue [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
The complete survey is too large, below is the beginning of it and a couple
lines of the survey.
I've created a facility survey, when the survey is taken the information
will go into the Access table. I have created queries to obtain averages in
Access because I haven't found a way to get FP to do them. So then I created
reports in FP to pull specific facilities...ie OH8099 display the information.
What I got from your prior postings is that it is not possible to display
this information correctly (by writing in script in SQL) if you are using
queries in Access to get your results in FP.
---------------------------------
> Can you post the SQL from your query here?
>
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> Expression Web Resources: http://www.spiderwebwoman.com/xweb/ > FrontPage Resources: http://www.spiderwebwoman.com/resources/ > Please reply to the newsgroup for the benefit of others
>
>
> "Syn1962" <Syn1962.RemoveThis@discussions.microsoft.com> wrote in message
> news:8E784FC2-0A47-44D1-9158-6EAD25D5577A@microsoft.com...
> > Kathleen,
> > I am having the same problem as well, I'm using a query to extract results
> > that I need to show in percentages correctly!
> > I created them in Front Page however, I also have Expression Web, any
> > chance
> > I can get the results to show correctly using EP? I've tried to find it
> > myself but so far I've had no luck in finding a solution to this anywhere.
> >
> > Your help is greatly appreciated.
> >
> > "Kathleen Anderson [MVP - FrontPage]" wrote:
> >
> >> If you are using an Access Query as your DRW Recordsource (as a 'View'),
> >> you
> >> can't modify the SQL, as far as I know. Can you copy the Access Query SQL
> >> into the Custom Query window of a new DRW and change it there?
> >>
> >> --
> >>
> >> ~ Kathleen Anderson
> >> Microsoft MVP - FrontPage
> >> Spider Web Woman Designs
> >> web: http://www.spiderwebwoman.com/resources/ > >> FrontPage Support: http://www.frontpagemvps.com/ > >>
> >>
> >>
> >>
> >> "Mick" <Mick.RemoveThis@discussions.microsoft.com> wrote in message
> >> news:26581493-DF4B-44FC-8031-ABB8580F4D84@microsoft.com...
> >> > 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.RemoveThis@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. 13) Posted: Thu Jul 03, 2008 11:28 am
Post subject: Re: Frontpage results - Number rounding issue [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"Syn1962" <Syn1962.DeleteThis@discussions.microsoft.com> wrote in message
news:D2A0A6E5-9795-4767-B7E4-326F8B4E1D5D@microsoft.com...
> The complete survey is too large, below is the beginning of it and a
> couple
> lines of the survey.
>
> I've created a facility survey, when the survey is taken the information
> will go into the Access table. I have created queries to obtain averages
> in
> Access because I haven't found a way to get FP to do them. So then I
> created
> reports in FP to pull specific facilities...ie OH8099 display the
> information.
> What I got from your prior postings is that it is not possible to display
> this information correctly (by writing in script in SQL) if you are using
> queries in Access to get your results in FP.
> ---------------------------------
>
>
> fp_sQry="SELECT * FROM 2008LocationAvg WHERE (Facility LIKE '%OH8099%')"
> fp_sDefault=""
> fp_sNoRecords="OH8099"
> fp_sDataConn="FacilitySurvey"
> fp_iMaxRecords=0
> fp_iCommandType=1
> fp_iPageSize=0
> fp_fTableFormat=False
> fp_fMenuFormat=False
> fp_sMenuChoice="Facility"
> fp_sMenuValue="Facility"
> fp_sColTypes="&Facility=202&AvgOfBS_Comfort_Temperature_Air_Flow=5&AvgOfBS_Performance_of_Routine_Cleaning_Tasks=5&AvgOfBS_Elevator_Services=5&AvgOfBS_Interior_Maintenance_and_Repairs=5&AvgOfBS_Exterior_Grounds_Maintenance=5&AvgOfBS_Parking_Adequacy_and_Availability=5&AvgOfBS_Recycling_and_Rubbish_Removal=5&AvgOfBS_Security=5&AvgOfBS_Emergency_Preparedness=5&AvgOfBS_Overall_Opinion_of_Building_Services=5&AvgOfBAI_Building_Exterior_Repair_and_Maintenance=5&AvgOfBAI_Parking_Landscaping_Appearance=5&AvgOfBAI_General_Quality_and_Condition_of_Office_Areas=5&AvgOfBAI_Condition_of_Your_Individual_Work_Station=5&AvgOfBAI_Quality_and_Condition_Conference_Meeting_Rooms=5&AvgOfBAI_Quality_and_Condition_Common_Areas=5&AvgOfBAI_Quality_and_Condition_of_Restrooms=5&AvgOfBAI_Suitability_of_Facility_to_Conduct_Meetings=5&AvgOfBAI_Overall_Opinion_of_Building_Appearance_Image=5&AvgOfBSS_Dining_Services=5&AvgOfBSS_Health_and_Fitness_Facility=5&AvgOfBSS_Mailing_Services=5&AvgOfBSS_Package_Shipping_Receiving=5&AvgOfBSS_Occupational_Health_and_Safety_Mgmt_Services=5&AvgOfBSS_Vending_Area=5&AvgOfBSS_Overall_Opinion_of_Business_Support_Services=5&AvgOfCRE_FMP_Communication_of_Building_Procedures=5&AvgOfCRE_FMP_Effective_Response_to_Service_Calls_and_Requests=5&AvgOfCRE_FMP_Delivery_on_Commitments=5&AvgOfCRE_FMP_Overall_Opinion_of_FMS_Performance=5&"
> fp_iDisplayCols=31
> fp_fCustomQuery=False
> BOTID=1
> fp_iRegion=BOTID
> %>
> <!--#include file="../../../../../_fpclass/fpdbrgn1.inc"-->
> <!--webbot bot="DatabaseRegionStart" endspan i-checksum="728" --><table
> BORDER="1" style="border-left-width: 0px; border-right-width: 0px;
> border-top-width: 0px">
> <tr>
> <td nowrap valign="top" style="border-style: none;
> border-width: medium" align="center">
> <font color="#008080">
> <b>OH8099</b></font></td>
> </tr>
> <tr>
> <td nowrap valign="top" style="border-left-style: none;
> border-left-width: medium; border-right-style: none; border-right-width:
> medium; border-top-style: none; border-top-width: medium;
> border-bottom-style: solid; border-bottom-width: 1px">
> </td>
> </tr>
> <tr>
> <td align="center">
> <!--webbot bot="DatabaseResultColumn"
> s-columnnames="Facility,AvgOfBS_Comfort_Temperature_Air_Flow,AvgOfBS_Performance_of_Routine_Cleaning_Tasks,AvgOfBS_Elevator_Services,AvgOfBS_Interior_Maintenance_and_Repairs,AvgOfBS_Exterior_Grounds_Maintenance,AvgOfBS_Parking_Adequacy_and_Availability,AvgOfBS_Recycling_and_Rubbish_Removal,AvgOfBS_Security,AvgOfBS_Emergency_Preparedness,AvgOfBS_Overall_Opinion_of_Building_Services,AvgOfBAI_Building_Exterior_Repair_and_Maintenance,AvgOfBAI_Parking_Landscaping_Appearance,AvgOfBAI_General_Quality_and_Condition_of_Office_Areas,AvgOfBAI_Condition_of_Your_Individual_Work_Station,AvgOfBAI_Quality_and_Condition_Conference_Meeting_Rooms,AvgOfBAI_Quality_and_Condition_Common_Areas,AvgOfBAI_Quality_and_Condition_of_Restrooms,AvgOfBAI_Suitability_of_Facility_to_Conduct_Meetings,AvgOfBAI_Overall_Opinion_of_Building_Appearance_Image,AvgOfBSS_Dining_Services,AvgOfBSS_Health_and_Fitness_Facility,AvgOfBSS_Mailing_Services,AvgOfBSS_Package_Shipping_Receiving,AvgOfBSS_Occupational_Health_and_Safety_Mgmt_Services,AvgOfBSS_Vending_Area,AvgOfBSS_Overall_Opinion_of_Business_Support_Services,AvgOfCRE_FMP_Communication_of_Building_Procedures,AvgOfCRE_FMP_Effective_Response_to_Service_Calls_and_Requests,AvgOfCRE_FMP_Delivery_on_Commitments,AvgOfCRE_FMP_Overall_Opinion_of_FMS_Performance"
> s-column="AvgOfBS_Comfort_Temperature_Air_Flow" b-tableformat="FALSE"
> b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
> preview="<font
> size="-1"><<</font>AvgOfBS_Comfort_Temperature_Air_Flow<font
> size="-1">>></font>" startspan
> s-ColumnTypes="202,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5"
> --><%=FP_FieldVal(fp_rs,"AvgOfBS_Comfort_Temperature_Air_Flow")%><!--webbot
> bot="DatabaseResultColumn" endspan i-checksum="42740" --></td>
> </tr>
> <tr>
> <td align="center">
> <!--webbot bot="DatabaseResultColumn"
> s-columnnames="Facility,AvgOfBS_Comfort_Temperature_Air_Flow,AvgOfBS_Performance_of_Routine_Cleaning_Tasks,AvgOfBS_Elevator_Services,AvgOfBS_Interior_Maintenance_and_Repairs,AvgOfBS_Exterior_Grounds_Maintenance,AvgOfBS_Parking_Adequacy_and_Availability,AvgOfBS_Recycling_and_Rubbish_Removal,AvgOfBS_Security,AvgOfBS_Emergency_Preparedness,AvgOfBS_Overall_Opinion_of_Building_Services,AvgOfBAI_Building_Exterior_Repair_and_Maintenance,AvgOfBAI_Parking_Landscaping_Appearance,AvgOfBAI_General_Quality_and_Condition_of_Office_Areas,AvgOfBAI_Condition_of_Your_Individual_Work_Station,AvgOfBAI_Quality_and_Condition_Conference_Meeting_Rooms,AvgOfBAI_Quality_and_Condition_Common_Areas,AvgOfBAI_Quality_and_Condition_of_Restrooms,AvgOfBAI_Suitability_of_Facility_to_Conduct_Meetings,AvgOfBAI_Overall_Opinion_of_Building_Appearance_Image,AvgOfBSS_Dining_Services,AvgOfBSS_Health_and_Fitness_Facility,AvgOfBSS_Mailing_Services,AvgOfBSS_Package_Shipping_Receiving,AvgOfBSS_Occupational_Health_and_Safety_Mgmt_Services,AvgOfBSS_Vending_Area,AvgOfBSS_Overall_Opinion_of_Business_Support_Services,AvgOfCRE_FMP_Communication_of_Building_Procedures,AvgOfCRE_FMP_Effective_Response_to_Service_Calls_and_Requests,AvgOfCRE_FMP_Delivery_on_Commitments,AvgOfCRE_FMP_Overall_Opinion_of_FMS_Performance"
> s-column="AvgOfBS_Performance_of_Routine_Cleaning_Tasks"
> b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside
> b-MenuFormat preview="<font
> size="-1"><<</font>AvgOfBS_Performance_of_Routine_Cleaning_Tasks<font
> size="-1">>></font>" startspan
> s-ColumnTypes="202,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5"
> --><%=FP_FieldVal(fp_rs,"AvgOfBS_Performance_of_Routine_Cleaning_Tasks")%><!--webbot
> bot="DatabaseResultColumn" endspan i-checksum="4999" --></td>
> </tr>
> <tr>
> -------------------------------------------
>
>
> "Kathleen Anderson" wrote:
>
>> Can you post the SQL from your query here?
>>
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> Expression Web Resources: http://www.spiderwebwoman.com/xweb/ >> FrontPage Resources: http://www.spiderwebwoman.com/resources/ >> Please reply to the newsgroup for the benefit of others
>>
>>
>> "Syn1962" <Syn1962.DeleteThis@discussions.microsoft.com> wrote in message
>> news:8E784FC2-0A47-44D1-9158-6EAD25D5577A@microsoft.com...
>> > Kathleen,
>> > I am having the same problem as well, I'm using a query to extract
>> > results
>> > that I need to show in percentages correctly!
>> > I created them in Front Page however, I also have Expression Web, any
>> > chance
>> > I can get the results to show correctly using EP? I've tried to find
>> > it
>> > myself but so far I've had no luck in finding a solution to this
>> > anywhere.
>> >
>> > Your help is greatly appreciated.
>> >
>> > "Kathleen Anderson [MVP - FrontPage]" wrote:
>> >
>> >> If you are using an Access Query as your DRW Recordsource (as a
>> >> 'View'),
>> >> you
>> >> can't modify the SQL, as far as I know. Can you copy the Access Query
>> >> SQL
>> >> into the Custom Query window of a new DRW and change it there?
>> >>
>> >> --
>> >>
>> >> ~ Kathleen Anderson
>> >> Microsoft MVP - FrontPage
>> >> Spider Web Woman Designs
>> >> web: http://www.spiderwebwoman.com/resources/ >> >> FrontPage Support: http://www.frontpagemvps.com/ >> >>
>> >>
>> >>
>> >>
>> >> "Mick" <Mick.DeleteThis@discussions.microsoft.com> wrote in message
>> >> news:26581493-DF4B-44FC-8031-ABB8580F4D84@microsoft.com...
>> >> > 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?
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>
(Msg. 14) Posted: Thu Jul 03, 2008 11:28 am
Post subject: Re: Frontpage results - Number rounding issue [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
here ya go
--------------------------------
SELECT [2008survey].Facility,
Avg([2008survey].BS_Comfort_Temperature_Air_Flow) AS
AvgOfBS_Comfort_Temperature_Air_Flow,
Avg([2008survey].BS_Performance_of_Routine_Cleaning_Tasks) AS
AvgOfBS_Performance_of_Routine_Cleaning_Tasks,
Avg([2008survey].BS_Elevator_Services) AS AvgOfBS_Elevator_Services,
Avg([2008survey].BS_Interior_Maintenance_and_Repairs) AS
AvgOfBS_Interior_Maintenance_and_Repairs,
Avg([2008survey].BS_Exterior_Grounds_Maintenance) AS
AvgOfBS_Exterior_Grounds_Maintenance,
Avg([2008survey].BS_Parking_Adequacy_and_Availability) AS
AvgOfBS_Parking_Adequacy_and_Availability,
Avg([2008survey].BS_Recycling_and_Rubbish_Removal) AS
AvgOfBS_Recycling_and_Rubbish_Removal, Avg([2008survey].BS_Security) AS
AvgOfBS_Security, Avg([2008survey].BS_Emergency_Preparedness) AS
AvgOfBS_Emergency_Preparedness,
Avg([2008survey].BS_Overall_Opinion_of_Building_Services) AS
AvgOfBS_Overall_Opinion_of_Building_Services,
Avg([2008survey].BAI_Building_Exterior_Repair_and_Maintenance) AS
AvgOfBAI_Building_Exterior_Repair_and_Maintenance,
Avg([2008survey].BAI_Parking_Landscaping_Appearance) AS
AvgOfBAI_Parking_Landscaping_Appearance,
Avg([2008survey].BAI_General_Quality_and_Condition_of_Office_Areas) AS
AvgOfBAI_General_Quality_and_Condition_of_Office_Areas,
Avg([2008survey].BAI_Condition_of_Your_Individual_Work_Station) AS
AvgOfBAI_Condition_of_Your_Individual_Work_Station,
Avg([2008survey].BAI_Quality_and_Condition_Conference_Meeting_Rooms) AS
AvgOfBAI_Quality_and_Condition_Conference_Meeting_Rooms,
Avg([2008survey].BAI_Quality_and_Condition_Common_Areas) AS
AvgOfBAI_Quality_and_Condition_Common_Areas,
Avg([2008survey].BAI_Quality_and_Condition_of_Restrooms) AS
AvgOfBAI_Quality_and_Condition_of_Restrooms,
Avg([2008survey].BAI_Suitability_of_Facility_to_Conduct_Meetings) AS
AvgOfBAI_Suitability_of_Facility_to_Conduct_Meetings,
Avg([2008survey].BAI_Overall_Opinion_of_Building_Appearance_Image) AS
AvgOfBAI_Overall_Opinion_of_Building_Appearance_Image,
Avg([2008survey].BSS_Dining_Services) AS AvgOfBSS_Dining_Services,
Avg([2008survey].BSS_Health_and_Fitness_Facility) AS
AvgOfBSS_Health_and_Fitness_Facility, Avg([2008survey].BSS_Mailing_Services)
AS AvgOfBSS_Mailing_Services,
Avg([2008survey].BSS_Package_Shipping_Receiving) AS
AvgOfBSS_Package_Shipping_Receiving,
Avg([2008survey].BSS_Occupational_Health_and_Safety_Mgmt_Services) AS
AvgOfBSS_Occupational_Health_and_Safety_Mgmt_Services,
Avg([2008survey].BSS_Vending_Area) AS AvgOfBSS_Vending_Area,
Avg([2008survey].BSS_Overall_Opinion_of_Business_Support_Services) AS
AvgOfBSS_Overall_Opinion_of_Business_Support_Services,
Avg([2008survey].CRE_FMP_Communication_of_Building_Procedures) AS
AvgOfCRE_FMP_Communication_of_Building_Procedures,
Avg([2008survey].CRE_FMP_Effective_Response_to_Service_Calls_and_Requests) AS
AvgOfCRE_FMP_Effective_Response_to_Service_Calls_and_Requests,
Avg([2008survey].CRE_FMP_Delivery_on_Commitments) AS
AvgOfCRE_FMP_Delivery_on_Commitments,
Avg([2008survey].CRE_FMP_Overall_Opinion_of_FMS_Performance) AS
AvgOfCRE_FMP_Overall_Opinion_of_FMS_Performance
FROM 2008survey
GROUP BY [2008survey].Facility;
-------------------------------------------------
"Kathleen Anderson" wrote:
> Can you post the SQL from your Access Query here?
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> Expression Web Resources: http://www.spiderwebwoman.com/xweb/ > FrontPage Resources: http://www.spiderwebwoman.com/resources/ > Please reply to the newsgroup for the benefit of others
>
>
>
> "Syn1962" <Syn1962 DeleteThis @discussions.microsoft.com> wrote in message
> news:D2A0A6E5-9795-4767-B7E4-326F8B4E1D5D@microsoft.com...
> > The complete survey is too large, below is the beginning of it and a
> > couple
> > lines of the survey.
> >
> > I've created a facility survey, when the survey is taken the information
> > will go into the Access table. I have created queries to obtain averages
> > in
> > Access because I haven't found a way to get FP to do them. So then I
> > created
> > reports in FP to pull specific facilities...ie OH8099 display the
> > information.
> > What I got from your prior postings is that it is not possible to display
> > this information correctly (by writing in script in SQL) if you are using
> > queries in Access to get your results in FP.
> > ---------------------------------
> >
> >
> > fp_sQry="SELECT * FROM 2008LocationAvg WHERE (Facility LIKE '%OH8099%')"
> > fp_sDefault=""
> > fp_sNoRecords="OH8099"
> > fp_sDataConn="FacilitySurvey"
> > fp_iMaxRecords=0
> > fp_iCommandType=1
> > fp_iPageSize=0
> > fp_fTableFormat=False
> > fp_fMenuFormat=False
> > fp_sMenuChoice="Facility"
> > fp_sMenuValue="Facility"
> >
fp_sColTypes="&Facility=202&AvgOfBS_Comfort_Temperature_Air_Flow=5&AvgOfBS_Performance_of_Routine_Cleaning_Tasks=5&AvgOfBS_Elevator_Services=5&AvgOfBS_Interior_Maintenance_and_Repairs=5&AvgOfBS_Exterior_Grounds_Maintenance=5&AvgOfBS_Parking_Adequacy_and_Availability=5&AvgOfBS_Recycling_and_Rubbish_Removal=5&AvgOfBS_Security=5&AvgOfBS_Emergency_Preparedness=5&AvgOfBS_Overall_Opinion_of_Building_Services=5&AvgOfBAI_Building_Exterior_Repair_and_Maintenance=5&AvgOfBAI_Parking_Landscaping_Appearance=5&AvgOfBAI_General_Quality_and_Condition_of_Office_Areas=5&AvgOfBAI_Condition_of_Your_Individual_Work_Station=5&AvgOfBAI_Quality_and_Condition_Conference_Meeting_Rooms=5&AvgOfBAI_Quality_and_Condition_Common_Areas=5&AvgOfBAI_Quality_and_Condition_of_Restrooms=5&AvgOfBAI_Suitability_of_Facility_to_Conduct_Meetings=5&AvgOfBAI_Overall_Opinion_of_Building_Appearance_Image=5&AvgOfBSS_Dining_Services=5&AvgOfBSS_Health_and_Fitness_Facility=5&AvgOfBSS_Mailing_Services=5&AvgOfBSS_Package_Shipping_Receiving=5&AvgOfBSS_Occupational_Health_and_Safety_Mgmt_Services=5&AvgOfBSS_Vending_Area=5&AvgOfBSS_Overall_Opinion_of_Business_Support_Services=5&AvgOfCRE_FMP_Communication_of_Building_Procedures=5&AvgOfCRE_FMP_Effective_Response_to_Service_Calls_and_Requests=5&AvgOfCRE_FMP_Delivery_on_Commitments=5&AvgOfCRE_FMP_Overall_Opinion_of_FMS_Performance=5&"
> > fp_iDisplayCols=31
> > fp_fCustomQuery=False
> > BOTID=1
> > fp_iRegion=BOTID
> > %>
> > <!--#include file="../../../../../_fpclass/fpdbrgn1.inc"-->
> > <!--webbot bot="DatabaseRegionStart" endspan i-checksum="728" --><table
> > BORDER="1" style="border-left-width: 0px; border-right-width: 0px;
> > border-top-width: 0px">
> > <tr>
> > <td nowrap valign="top" style="border-style: none;
> > border-width: medium" align="center">
> > <font color="#008080">
> > <b>OH8099</b></font></td>
> > </tr>
> > <tr>
> > <td nowrap valign="top" style="border-left-style: none;
> > border-left-width: medium; border-right-style: none; border-right-width:
> > medium; border-top-style: none; border-top-width: medium;
> > border-bottom-style: solid; border-bottom-width: 1px">
> > </td>
> > </tr>
> > <tr>
> > <td align="center">
> > <!--webbot bot="DatabaseResultColumn"
> >
s-columnnames="Facility,AvgOfBS_Comfort_Temperature_Air_Flow,AvgOfBS_Performance_of_Routine_Cleaning_Tasks,AvgOfBS_Elevator_Services,AvgOfBS_Interior_Maintenance_and_Repairs,AvgOfBS_Exterior_Grounds_Maintenance,AvgOfBS_Parking_Adequacy_and_Availability,AvgOfBS_Recycling_and_Rubbish_Removal,AvgOfBS_Security,AvgOfBS_Emergency_Preparedness,AvgOfBS_Overall_Opinion_of_Building_Services,AvgOfBAI_Building_Exterior_Repair_and_Maintenance,AvgOfBAI_Parking_Landscaping_Appearance,AvgOfBAI_General_Quality_and_Condition_of_Office_Areas,AvgOfBAI_Condition_of_Your_Individual_Work_Station,AvgOfBAI_Quality_and_Condition_Conference_Meeting_Rooms,AvgOfBAI_Quality_and_Condition_Common_Areas,AvgOfBAI_Quality_and_Condition_of_Restrooms,AvgOfBAI_Suitability_of_Facility_to_Conduct_Meetings,AvgOfBAI_Overall_Opinion_of_Building_Appearance_Image,AvgOfBSS_Dining_Services,AvgOfBSS_Health_and_Fitness_Facility,AvgOfBSS_Mailing_Services,AvgOfBSS_Package_Shipping_Receiving,AvgOfBSS_Occupational_Health_and_Safety_Mgmt_Services,AvgOfBSS_Vending_Area,AvgOfBSS_Overall_Opinion_of_Business_Support_Services,AvgOfCRE_FMP_Communication_of_Building_Procedures,AvgOfCRE_FMP_Effective_Response_to_Service_Calls_and_Requests,AvgOfCRE_FMP_Delivery_on_Commitments,AvgOfCRE_FMP_Overall_Opinion_of_FMS_Performance"
> > s-column="AvgOfBS_Comfort_Temperature_Air_Flow" b-tableformat="FALSE"
> > b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
> > preview="<font
> > size="-1"><<</font>AvgOfBS_Comfort_Temperature_Air_Flow<font
> > size="-1">>></font>" startspan
> > s-ColumnTypes="202,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5"
> > --><%=FP_FieldVal(fp_rs,"AvgOfBS_Comfort_Temperature_Air_Flow")%><!--webbot
> > bot="DatabaseResultColumn" endspan i-checksum="42740" --></td>
> > </tr>
> > <tr>
> > <td align="center">
> > <!--webbot bot="DatabaseResultColumn"
> >
s-columnnames="Facility,AvgOfBS_Comfort_Temperature_Air_Flow,AvgOfBS_Performance_of_Routine_Cleaning_Tasks,AvgOfBS_Elevator_Services,AvgOfBS_Interior_Maintenance_and_Repairs,AvgOfBS_Exterior_Grounds_Maintenance,AvgOfBS_Parking_Adequacy_and_Availability,AvgOfBS_Recycling_and_Rubbish_Removal,AvgOfBS_Security,AvgOfBS_Emergency_Preparedness,AvgOfBS_Overall_Opinion_of_Building_Services,AvgOfBAI_Building_Exterior_Repair_and_Maintenance,AvgOfBAI_Parking_Landscaping_Appearance,AvgOfBAI_General_Quality_and_Condition_of_Office_Areas,AvgOfBAI_Condition_of_Your_Individual_Work_Station,AvgOfBAI_Quality_and_Condition_Conference_Meeting_Rooms,AvgOfBAI_Quality_and_Condition_Common_Areas,AvgOfBAI_Quality_and_Condition_of_Restrooms,AvgOfBAI_Suitability_of_Facility_to_Conduct_Meetings,AvgOfBAI_Overall_Opinion_of_Building_Appearance_Image,AvgOfBSS_Dining_Services,AvgOfBSS_Health_and_Fitness_Facility,AvgOfBSS_Mailing_Services,AvgOfBSS_Package_Shipping_Receiving,AvgOfBSS_Occupational_Health_and_Safety_Mgmt_Services,AvgOfBSS_Vending_Area,AvgOfBSS_Overall_Opinion_of_Business_Support_Services,AvgOfCRE_FMP_Communication_of_Building_Procedures,AvgOfCRE_FMP_Effective_Response_to_Service_Calls_and_Requests,AvgOfCRE_FMP_Delivery_on_Commitments,AvgOfCRE_FMP_Overall_Opinion_of_FMS_Performance"
> > s-column="AvgOfBS_Performance_of_Routine_Cleaning_Tasks"
> > b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside
> > b-MenuFormat preview="<font
> > size="-1"><<</font>AvgOfBS_Performance_of_Routine_Cleaning_Tasks<font
> > size="-1">>></font>" startspan
> > s-ColumnTypes="202,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5"
> > --><%=FP_FieldVal(fp_rs,"AvgOfBS_Performance_of_Routine_Cleaning_Tasks")%><!--webbot
> > bot="DatabaseResultColumn" endspan i-checksum="4999" --></td>
> > </tr>
> > <tr>
> > -------------------------------------------
> >
> >
> > "Kathleen Anderson" wrote:
> >
> >> Can you post the SQL from your query here?
> >>
> >>
> >> --
> >>
> >> ~ Kathleen Anderson
> >> Microsoft MVP - FrontPage
> >> Spider Web Woman Designs
> >> Expression Web Resources: http://www.spiderwebwoman.com/xweb/ > >> FrontPage Resources: http://www.spiderwebwoman.com/resources/ > >> Please reply to the newsgroup for the benefit of others
> >>
> >>
> >> "Syn1962" <Syn1962 DeleteThis @discussions.microsoft.com> wrote in message
> >> news:8E784FC2-0A47-44D1-9158-6EAD25D5577A@microsoft.com...
> >> > Kathleen,
> >> > I am having the same problem as well, I'm using a query to extract
> >> > results
> >> > that I need to show in percentages correctly!
> >> > I created them in Front Page however, I also have Expression Web, any
> >> > chance
> >> > I can get the results to show correctly using EP? I've tried to find
> >> > it
> >> > myself but so far I've had no luck in finding a solution to this
> >> > anywhere.
> >> >
> >> > Your help is greatly appreciated.
> >> >
> >> > "Kathleen Anderson [MVP - FrontPage]" wrote:
> >> >
> >> >> If you are using an Access Query as your DRW Recordsource (as a
> >> >> 'View'),
> >> >> you
> >> >> can't modify the SQL, as far as I know. Can you copy the Access Query
> >> >> SQL
> >> >> into the Custom Query window of a new DRW and change it there?
> >> >>
> >> >> --
> >> >>
> >> >> ~ Kathleen Anderson
> >> >> Microsoft MVP - FrontPage
> >> >> Spider Web Woman Designs
> >> >> web: http://www.spiderwebwoman.com/resources/ > >> >> FrontPage Support: http://www.frontpagemvps.com/ > >> >>
> >> >>
> >> >>
> >> >>
> >> >> "Mick" <Mick DeleteThis @discussions.microsoft.com> wrote in message
> >> >> news:26581493-DF4B-44FC-8031-ABB8580F4D84@microsoft.com...
> >> >> > 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
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
