pcsoft.us.windevCopyright 2026, PC SOFT4 Jun 2017 21:32:51 Z4 Jun 2017 21:32:51 ZHi, I need to: 1. Get some rows that are between the given dates 2. Calculate SUM on two columns with GROUP BY 3. Subtract these sums and put the result in a new column It seems that I need 3 queries taking data from one another, in a row when I want to use query editor: A. Query1: select rows between the dates B. Query2: do the sums C. Query3: select the sums and make a formula using sums But I couldn't make query from query from a query work. Only query from a query is possible. Any suggestions how to go around it in the query editor ? Thanks in advance /Jacek30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61136-problem-with-aggregate-functions-and-formula-query-editor/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)