pcsoft.us.windevCopyright 2026, PC SOFT22 Jun 2017 10:03:00 Z20 Jun 2017 11:50:00 ZHello All, I trust this finds you all well. I am building two queries to be used in a join. I would like to query data from two different months. For one month I want the values to be positive (+ve) and the other month Negative (-ve). I want to build a report out of the 'joined queries' such that query1.value+query2.value will give me the net of the two [ query1.value(+ve) + query2.value (-ve) ]=Net. How do I get the queryvalue "negated" in the query builder? Thanks in advance. Sam30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61372-wd21-how-negate-value-when-defining-query/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61372-wd21-how-negate-value-when-defining-query-61406/read.awp22 Jun 2017 10:03:00 ZSam, you could also use a UNION for that SELECT SUM(netvalue) as netvalue, othervalue1, othervalue2 FROM ( SELECT table1…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61372-wd21-how-negate-value-when-defining-query-61406/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61372-wd21-how-negate-value-when-defining-query-61406/read.awpWD21 - How to negate a value when defining a Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61372-wd21-how-negate-value-when-defining-query-61397/read.awp21 Jun 2017 17:16:00 Z1 Make the two queries by selecting the right data. data --Between two dates -- You can select this in the editor or add two par…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61372-wd21-how-negate-value-when-defining-query-61397/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61372-wd21-how-negate-value-when-defining-query-61397/read.awpWD21 - How to negate a value when defining a Query