SELECT ROUND( ( TOTAL / HIT ), 1 ) AS output_result
--
Hong Wu
Senior Web Developer
DoubleSpace
Jeremy Toevs wrote:
>
> Is there a way to make it round to the nearest tenth?
>
> >>> Hong <[EMAIL PROTECTED]> 10/16/00 03:20PM >>>
> use SQL math divide operator,
>
> SELECT ( TOTAL / HIT ) AS output_result
> ...
>
> --
> Hong Wu
> Senior Web Developer
> DoubleSpace
>
> Jeremy Toevs wrote:
> >
> > Can you divide field in a query an output the results. Bacially, I have a TOTAL
>field that I want to divid by a HIT field. How would I do that if you can?
> >
> > Thanks for the help.
> >
> > Jeremy
> >
> > ------------------------------------------------------------------------------
> > Archives: http://www.mail-archive.com/[email protected]/
> > 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.
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> 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.mail-archive.com/[email protected]/
> 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.
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
