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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
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.

Reply via email to