Percentage in database results

[Nash13]

I have a database that has a field formatted as a percentage. When I used the
Database Results wizard, the data appears as a number so that '33%' becomes
'.33'. How can I get the wizard to display my data as a percentage?

Thanks

 

[Kathleen Anderson [MVP - FrontPage]]

http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#percent

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Nash13]

Thanks but that may not apply. The database results page is using a webbot
and doesn't seem to allow changes or additions of sql without crashing it. Am
I missing it?

 

[Kathleen Anderson [MVP - FrontPage]]

Find the SQL in the gray-colored code and change it. Save the changes while
still in Code/HTML view. You will notice that once you've saved your changes
they are also made to the maroon colored code - that is by design. The
maroon colored code should never be touched; it's generated by the gray code
at save time.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others.

 

[Nash13]

Still not having any luck. Here is the code for the field that I would like
to change to a percentage. Can you help me locate where it should go?

<!--webbot bot="DatabaseResultColumn"
s-columnnames="ID,Name,HRIS#,Supervisor,Bill Pay,Bill Pay
Total,Checking,Checking Total,Credit,Credit Total,Partner,Partner
Total,Savings,Savings Total,Warm Xfer,Warm Xfer Total" s-column="Warm Xfer"
b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Warm Xfer<font
size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Warm
Xfer")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="19164"
--></td>

 

[Kathleen Anderson [MVP - FrontPage]]

The SQL is located in the first <!--webbot bot="DatabaseRegionStart" - look
for a statement that begins with s-sql="SELECT

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others.

 

[Nash13]

Sorry I haven't gone away yet, but this still is giving me issues. I tried
that one as well without any luck. WarmXfer is the one I am working on.

<!--webbot bot="DatabaseRegionStart"
s-columnnames="Name,Supervisor,WarmXfer"
s-columntypes="3,202,5,202,5,5,5,5,5,5,5,5,5,5,5,202"
s-dataconnection="AugustBlitz" b-tableformat="TRUE" b-menuformat="FALSE"
s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="FALSE" s-recordsource="Aug03Premier"
s-displaycolumns="Name,Supervisor,WarmXfer" s-criteria s-order s-sql="SELECT
* FROM Aug03" b-procedure="FALSE" clientside suggestedext="asp"
s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256"
i-groupsize="0" botid="0" u-dblib="../_fpclass/fpdblib.inc"
u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc"
tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font
color="#000000">This is the start of a Database Results
region.</font></td></tr>" startspan --><!--#include
file="../_fpclass/fpdblib.inc"-->

 

[Kathleen Anderson [MVP - FrontPage]]

Change s-sql="SELECT * FROM Aug03"

to

s-sql="SELECT [Name],Supervisor,Format(WarmXfer,'##0.00##%') as newWarmXfer
FROM Aug03"

I noticed you used the word "Name" as a field name in your table - Name is a
reserved word in Access 2002 and in later versions of Access
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335 that's
why I put the brackets around it. You might think about changing that field
name to something else.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others.

 

[Nash13]

Yeah, I know about the name thing. But it is linked to other systems so our
hands are tied there.

Unfotunately I copied and pasted it exactly from what you have, and it still
doesn't work. I think we will just leave it as is.

Change s-sql="SELECT * FROM Aug03"

to

s-sql="SELECT [Name],Supervisor,Format(WarmXfer,'##0.00##%') as newWarmXfer
FROM Aug03"

I noticed you used the word "Name" as a field name in your table - Name is a
reserved word in Access 2002 and in later versions of Access
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335 that's
why I put the brackets around it. You might think about changing that field
name to something else.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others.

Sorry I haven't gone away yet, but this still is giving me issues. I tried
that one as well without any luck. WarmXfer is the one I am working on.

<!--webbot bot="DatabaseRegionStart"
s-columnnames="Name,Supervisor,WarmXfer"
s-columntypes="3,202,5,202,5,5,5,5,5,5,5,5,5,5,5,202"
s-dataconnection="AugustBlitz" b-tableformat="TRUE" b-menuformat="FALSE"
s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="FALSE" s-recordsource="Aug03Premier"
s-displaycolumns="Name,Supervisor,WarmXfer" s-criteria s-order
s-sql="SELECT
* FROM Aug03" b-procedure="FALSE" clientside suggestedext="asp"
s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256"
i-groupsize="0" botid="0" u-dblib="../_fpclass/fpdblib.inc"
u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc"
tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00"
width="100%"><font
color="#000000">This is the start of a Database Results
region.</font></td></tr>" startspan --><!--#include
file="../_fpclass/fpdblib.inc"-->