I need to use SUM in my query to add up some fields. How do I do this in the query builder. Thanks!

Hi Matt,
Could you please explain a little more detailed what exactly do you need to achieve?

I'm wanting to accomplish the same as this:

SELECT
sum(transactions)
FROM checkbook

You can sum the values from your database table column using DMXzone HTML5 Data Bindings Formatter - www.dmxzone.com/go/22124/html5-data-bindings-formatter

In that solution, does the database still do the "work" of calculating the result? - or is it passing all of the data into the application first for processing?

As the Data Bindings is AJAX Based, the data is calculated while the page loads.

OK, since I anticipate that this will grow into quite a bit of data, I should probably just choose to use a mySQL view - to keep the processing at the database. Thanks for your help.