I'm trying to figure a percentage in a query. I don't know if it's possible. I would like to D_Loss / D_Goal and then output the percentage. I'm using an Access database if that helps.
<CFQUERY NAME="QDiet" DATASOURCE="met"> SELECT D_ID, D_Name, D_Loss, D_Goal FROM diet ORDER BY diet.D_Name </CFQUERY> Thanks! Ann Harrell ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
