Britta & Jay,
Have you tried #DollarFormat(UnitPrice)#? Maybe I'm missing something,
but it seems like that's what you want on the CF side. On the Access
side, use Fred's instructions.
hth,
ron allen hornbaker õ¿õ¬
mailto:[EMAIL PROTECTED] ~
humankind systems, inc.
> Thanks Fred!
>
> It now displays 14.0 instead of 14.0000, and if I add .95 it
> displays 14.95,
> so this is effective to be able to do calculations. Any
> suggestions about a
> fix for the missing 0 in display? It's only cosmetic I know
> that would make
> it perfect!
>
> I've tried doing this to adjust the display:
>
> <CFIF UnitPrice IS NOT "">
> AND UnitPrice IS LIKE '%.0'
> <td align="center"><font size="2">$#UnitPrice#0</font></td>
> <cfelse><td align="center"><font size="2">
> $#UnitPrice#</font></td></cfif>
>
> The problem is that it prints out a line of
> AND UnitPrice IS LIKE '%.0'
> for every product in the search.
>
> Thanks again for your help!
> Britta
>
> ----- Original Message -----
> From: "Fred Sanders" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, April 25, 2000 7:33 AM
> Subject: Re: maintaining decimal place
>
>
> > Set the Data Type to "Number",Field Size to "Double",
> Format to "Fixed"
> and
> > Decimal Places to "2".
> > That should do it for you two.
> >
> > Fred
> >
> > ----- Original Message -----
> > From: "Britta Wingenroth (Design Department)"
> <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, April 25, 2000 1:55 AM
> > Subject: Re: maintaining decimal place
> >
> >
> > > I'm looking for the answer to the same question. I'm
> using Access and
> as
> > > long as I have my values set as currency, once the query
> runs $14.00
> turns
> > > into14.0000. If anyone could help, we'd both appreciate
> not loosing our
> > > minds!
> > >
> > > Britta
> > >
> > > ----- Original Message -----
> > > From: "Jay Wigginton" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Monday, April 17, 2000 10:10 AM
> > > Subject: maintaining decimal place
> > >
> > >
> > > > I am having trouble for some reason with having data
> entered via a
> form
> > > into
> > > > an Access database and keeping the decimal places
> entered in place...
> > > > person enters 2.5 the database rounds it to 2... if I set the
> database
> > to
> > > > number, type double... it maintains the decimal places
> but then CF
> > > displays
> > > > all the numbers entered with a decimal place and a zero
> added... 2.5
> > > > entered displays as 2.5.... 181 entered displays as
> 181.0 I have
> > never
> > > > had this problem before that I can remember.... Am I
> losing my mind
> > here
> > > > and just not doing something right?
> > > >
> > > > thanks
> > > > Jay
> > > >
> > >
> >
> >
> --------------------------------------------------------------
> ------------
> > > ----
> > > > Archives: http://www.eGroups.com/list/cf-talk
> > > > To Unsubscribe visit
> > >
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with
'unsubscribe'
in
> > the body.
> > >
> >
>
> ----------------------------------------------------------------------
----
> ----
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
>
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> the body.
>
> ----------------------------------------------------------------------
----
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
the body.
>
------------------------------------------------------------------------
------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
