Thanks, Nathan. I didn't work for me, but that probably has more to do wi th the lateness of the hour than anything. I'll start fresh in the morning.
Ann Harrell -----Original Message----- From: Nathan Chen [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 17, 2002 11:01 PM To: CF-Talk Subject: Re: Calculations in Query? Of course it is possible. Try SELECT D_ID, D_Name, D_Loss/D_Goal*100 as MyValue FROM diet Then put a % after the output value. e.g. <cfoutput>#MyValue#</cfoutput>% ----- Original Message ----- From: "Ann Harrell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 17, 2002 8:41 PM Subject: Calculations in Query? > 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 usi ng 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
