Simple Math in SQL Query or cfset

Calculated fields in the DB vs <cfset>?

It would seem simple, but:

ACCESS DB ;>(

CF9

IIS

<cfquery name="get_total" datasource="#Request.BaseDSN#">
SELECT SUM((current_charge+penalty)-credit) AS total
FROM moorings
WHERE mooring_ID = #URL.mooring_ID#
</cfquery>

<cfdump var="#total#"> 

Variable TOTAL is undefined?

or

<cfset subtotal = current_charge+penalty>

<cfset total = subtotal-credit>

Variable CURRENT_CHARGE is undefined?

Missing ',", (, #'s?

Thanks