pcsoft.us.windevCopyright 2026, PC SOFT29 Nov 2014 09:44:00 Z26 Nov 2014 19:56:00 ZHello all, I have in my project a data file as in the attach, now i want to make a view where i can see from each "Kenteken" one line with the total of "Bedrag1" Just like this: KENTEKEN DEBITEURNO BEDRAG1 XT-86-TK 10824 283,25 XT-JZ-27 10823 700,76 Etc. Thanks! [attachment 1255 Knipsel.JPG]30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49205-create-view-with-sum/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49205-create-view-with-sum-49248/read.awp29 Nov 2014 09:44:00 ZHi 1. Maybe you can try with SQL Query "SELECT Debiteurno, Kenteken FROM MyFile,...." 2. You can create view and read records …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49205-create-view-with-sum-49248/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49205-create-view-with-sum-49248/read.awpCreate View with sumguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49205-create-view-with-sum-49210/read.awp27 Nov 2014 09:39:00 ZHi Sammy, Do you want to anchor the table as well? If so, at least in version 18 < there is an odd bug in the table when addi…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49205-create-view-with-sum-49210/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49205-create-view-with-sum-49210/read.awpCreate View with sumguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49205-create-view-with-sum-49207/read.awp26 Nov 2014 20:46:00 ZHi Sammy, If this is an SL request behind the table you can simply GROUP BY Kenteken and SUM the Bedrag1 field. This will giv…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49205-create-view-with-sum-49207/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49205-create-view-with-sum-49207/read.awpCreate View with sum