calculations for all records instead of displayed list

Hi,
proceed to the Visual Editor tab. Create PHP Code Snippet. Here is a sample code for MySQL to display the number of entries:

I actually I needed the total. But I knew what to change. The code is below. I do have one additional factor. They also want this to reflect specific departments. Let's say I want this to show the sums for all entries from the English department. If there a way to refine this based on a criteria in a different field?
Function BudgetQuery1_Snippet1(byref params)

sql = "select sum(Budget_Deduction) from BudgetQuery1"

set rstmp=CustomQuery(sql)

Response.Write rstmp(0)

rstmp.close

set rstmp=nothing

Hi,
you can modify the query in the following way:

Thanks. That was helpful. I have just been told of one other thing. Is there a way to display the total based on the department and a session variable. As in Session("AccessLevel"), access level being department managers.
I originally just listed the department totals accress the top of the list, like

NWV Academic Affairs: {$event BudgetQuery1_Snippet1} Â NWV Arts and Kinesiology: {$event BudgetQuery1_Snippet2}

but they now what only specific departmental access levels to see their own depaartment total only.

Hi,
you just need to concat access level at the end. Here is a sample for static permissions:

Thank you.