I would like to perform a function on a Field

[lobbyskids2]

Basically I have an imported spreadsheet in base with a query related to it that show name, date and total revenue. This is all in one row. For each sale I get I add another row or record. I would like to know if there is a way that I can run a function on multiple records in the query. I would like to sum the total sales revenue which is arranged like this.

Name Date Sales Rev

---

Mr A 12/12/12 £10

---

Mr B 13/12/12 £20

---

Mr C 14/12/12 £15

I would like to sum the Sales rev field in libre office base not calc.

[lobbyskids2]

Sorry on the formatting for the little example table I put in. I didnt know it would do that.

[bencomp]

Could you change the question to make it more to the point? The answer to “I would like to …” would be “Go ahead.”

[mariosv]

Hi Alexander, please take a look in the documentation:
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide
In page 128 of the Base Handbook: Full book, there are information about how to use functions in a query.

[frofa]

Basically you need to use the SQL SUM function in your query - see HERE.